Query to Element Entry Details in Fusion Application(HCM)

Introduction

This Post illustrates the steps required to Element Entry Details in fusion Application

Script to Element Entry Details in Fusion Application

SELECT *

FROM per_all_people_f peo,

per_all_assignments_f asg,

per_person_names_f per_name,

per_periods_of_service ser,

per_person_types_tl per_typ,

per_legal_employers ple,

pay_rel_groups_dn payrel,

pay_assigned_payrolls_dn papd,

pay_all_payrolls_f pay,

pay_element_entry_values_f peevf,

pay_input_values_f pivf,

pay_element_entries_f peef,

pay_element_types_f petf,

pay_entry_usages peu

WHERE asg.person_id = peo.person_id

AND ser.person_id = peo.person_id

AND per_name.person_id = peo.person_id

AND asg.assignment_id = payrel.assignment_id

AND asg.period_of_service_id = ser.period_of_service_id

AND asg.person_type_id = per_typ.person_type_id

AND asg.legal_entity_id = ple.organization_id

AND papd.payroll_term_id = payrel.parent_rel_group_id

AND papd.payroll_id = pay.payroll_id

AND peevf.element_entry_id = peef.element_entry_id

AND pivf.element_type_id = petf.element_type_id

–AND pivf.base_name = ‘Amount’

–AND petf.base_element_name IN (‘Basic’)

AND peu.element_entry_id = peef.element_entry_id

AND peevf.input_value_id = pivf.input_value_id

AND peu.payroll_relationship_id = payrel.payroll_relationship_id

AND payrel.group_type = ‘A’

AND asg.primary_flag = ‘Y’

AND asg.assignment_type IN (‘E’, ‘C’, ‘N’, ‘P’)

AND asg.assignment_status_type = ‘ACTIVE’

AND per_name.name_type = ‘GLOBAL’

AND ple.status = ‘A’

AND per_typ.LANGUAGE = USERENV (‘LANG’)

AND TRUNC (SYSDATE) BETWEEN peo.effective_start_date AND peo.effective_end_date

AND TRUNC (SYSDATE) BETWEEN asg.effective_start_date AND asg.effective_end_date

AND TRUNC (SYSDATE) BETWEEN per_name.effective_start_date

AND per_name.effective_end_date

AND TRUNC (SYSDATE) BETWEEN ple.effective_start_date AND ple.effective_end_date

AND TRUNC (SYSDATE) BETWEEN payrel.start_date AND payrel.end_date

AND TRUNC (SYSDATE) BETWEEN papd.start_date

AND NVL (papd.lspd,

TO_DATE (’31/12/4712′, ‘DD/MM/YYYY’)

)

AND TRUNC (SYSDATE) BETWEEN pay.effective_start_date(+) AND pay.effective_end_date(+)

AND TRUNC (SYSDATE) BETWEEN pivf.effective_start_date

AND pivf.effective_end_date

AND TRUNC (SYSDATE) BETWEEN peevf.effective_start_date

AND peevf.effective_end_date

AND TRUNC (SYSDATE) BETWEEN petf.effective_start_date

AND petf.effective_end_date

 

Queries

Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.