Saturday, December 18, 2021

Query to fetch Elements attached to Employee in Oracle APPS

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%'

5 comments:

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)