DBA Data[Home] [Help]

APPS.PQP_GB_PENSION_FUNCTIONS dependencies on PAY_ELEMENT_ENTRIES_F

Line 23: FROM pay_element_entries_f pee

19: ,c_effective_date DATE
20: )
21: IS
22: SELECT DISTINCT (pee.element_link_id)
23: FROM pay_element_entries_f pee
24: WHERE pee.assignment_id = c_assignment_id
25: AND c_effective_date BETWEEN pee.effective_start_date
26: AND pee.effective_end_date
27: AND entry_type = 'E'

Line 150: FROM pay_element_entries_f pee

146: ,c_effective_date DATE
147: )
148: IS
149: SELECT pee.element_entry_id, pee.effective_start_date, pee.effective_end_date
150: FROM pay_element_entries_f pee
151: ,pay_element_links_f pel
152: WHERE pee.assignment_id = c_assignment_id
153: AND pee.element_link_id = pel.element_link_id
154: AND pee.entry_type = 'E'