DBA Data[Home] [Help]

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_ELEMENT_LINKS_F

Line 947: ,pay_element_links_f pel

943: ) is
944: select pel.element_type_id
945: ,pee.element_entry_id
946: from pay_element_entries_f pee
947: ,pay_element_links_f pel
948: where pee.assignment_id = c_assignment_id
949: and (pee.effective_start_date between c_effective_start_date
950: and c_effective_end_date
951: or

Line 1030: ,pay_element_links_f pel

1026: ,p_effective_date IN DATE
1027: ,p_element_type_id IN NUMBER ) IS
1028: SELECT pee.element_entry_id
1029: FROM pay_element_entries_f pee
1030: ,pay_element_links_f pel
1031: WHERE pee.assignment_id = p_assignment_id
1032: AND pel.element_link_id = pee.element_link_id
1033: AND pel.element_type_id = p_element_type_id
1034: AND ((p_effective_date BETWEEN pee.effective_start_date