APPS.PQP_GB_PENSION_FUNCTIONS dependencies on PAY_ELEMENT_LINKS_F

Line 30: FROM pay_element_links_f pel

26: AND pee.effective_end_date
27: AND entry_type = 'E'
28: AND EXISTS (
29: SELECT 1
30: FROM pay_element_links_f pel
31: ,pay_element_types_f pet
32: ,pay_element_classifications pec
33: WHERE pel.element_link_id = pee.element_link_id
34: AND pel.element_type_id <> c_element_type_id

Line 53: FROM pay_element_links_f

49: -- from element links
50: CURSOR csr_get_ele_type_id (c_element_link_id NUMBER, c_effective_date DATE)
51: IS
52: SELECT element_type_id
53: FROM pay_element_links_f
54: WHERE element_link_id = c_element_link_id
55: AND c_effective_date BETWEEN effective_start_date
56: AND effective_end_date;
57:

Line 67: FROM pay_element_links_f

63: ,c_effective_date DATE
64: )
65: IS
66: SELECT element_link_id
67: FROM pay_element_links_f
68: WHERE element_type_id = c_element_type_id
69: AND business_group_id = c_business_group_id
70: AND c_effective_date BETWEEN effective_start_date
71: AND effective_end_date;

Line 151: ,pay_element_links_f pel

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'
155: AND c_effective_date BETWEEN pee.effective_start_date