SELECT pbg.NAME business_group_name , papf.employee_number , papf.full_name , petf.element_name , peef.effective_start_date FROM per_all_people_f papf , per_all_assignments_f paaf , pay_element_entries_f peef , pay_element_types_f petf , per_business_groups pbg WHERE papf.person_id = paaf.person_id AND papf.business_group_id = pbg.business_group_id AND pbg.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID') AND papf.current_employee_flag = 'Y' AND paaf.assignment_id = peef.assignment_id AND peef.element_type_id = petf.element_type_id AND Trunc (sysdate) BETWEEN papf.effective_start_date AND papf.effective_end_date AND Trunc (sysdate) BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND Trunc (sysdate) BETWEEN peef.effective_start_date AND peef.effective_end_date AND Trunc (sysdate) BETWEEN petf.effective_start_date AND petf.effective_end_date AND petf.element_name LIKE 'PF%'
Saturday, January 29, 2022
Query to find all elements attached to employee in oracle apps
Subscribe to:
Post Comments (Atom)
Types of animations
Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...
-
Approval Management Engine FAQ 1. AME – What is it? i. AME is a simple to use Rules Engine for Defining Approval Policy ii. AME is ...
-
Register Custom Tables in Oracle Apps Say you have a custom table called “ERPS_EMPL...
-
OU & ORG ID & ORG CODE & ORG NAME ================================== select OPERATING_UNIT,ORGANIZATION_ID,ORGANIZATION_CODE...
No comments:
Post a Comment