APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_ELEMENT_ENTRIES_F

Line 926: -- pay_element_entries_f table from HR_FP G onwards

922: g_tab_osla_cl_ele_ids t_ele_ids_from_bal;
923: -- Cursor to get element entries information
924:
925: -- As element type id is available as a new column in
926: -- pay_element_entries_f table from HR_FP G onwards
927: -- we can fetch element type id from this table directly
928: -- so modified this cursor as a part of Bug fix 3163458
929:
930: Cursor csr_get_eet_info

Line 937: from pay_element_entries_f pee

933: ,c_effective_end_date date
934: ) is
935: select pel.element_type_id
936: ,pee.element_entry_id
937: from pay_element_entries_f pee
938: ,pay_element_links_f pel
939: where pee.assignment_id = c_assignment_id
940: and (pee.effective_start_date between c_effective_start_date
941: and c_effective_end_date

Line 1020: FROM pay_element_entries_f pee

1016: CURSOR csr_element_entries(p_assignment_id IN NUMBER
1017: ,p_effective_date IN DATE
1018: ,p_element_type_id IN NUMBER ) IS
1019: SELECT pee.element_entry_id
1020: FROM pay_element_entries_f pee
1021: ,pay_element_links_f pel
1022: WHERE pee.assignment_id = p_assignment_id
1023: AND pel.element_link_id = pee.element_link_id
1024: AND pel.element_type_id = p_element_type_id

Line 1471: ,pay_element_entries_f peef

1467: ,ppa.date_earned
1468: FROM pay_entry_process_details perd
1469: ,pay_assignment_actions paa
1470: ,pay_payroll_actions ppa
1471: ,pay_element_entries_f peef
1472: WHERE peef.assignment_id = p_assignment_id
1473: AND perd.element_entry_id = peef.element_entry_id
1474: AND perd.source_asg_action_id = paa.assignment_action_id
1475: AND paa.payroll_action_id = ppa.payroll_action_id