APPS.PSP_ENC_ASSIGNMENT_CHANGES dependencies on PAY_ELEMENT_LINKS_F

Line 27: FROM pay_element_links_f pel

23: p_effective_date IN DATE)
24: IS
25: CURSOR element_cur IS
26: SELECT pel.element_type_id
27: FROM pay_element_links_f pel
28: WHERE pel.element_link_id = p_element_link_id
29: AND EXISTS (SELECT pee.element_type_id
30: FROM psp_enc_elements pee
31: WHERE pee.element_type_id = pel.element_type_id

Line 108: FROM pay_element_links_f pel

104: l_payroll_id NUMBER DEFAULT NULL;
105:
106: CURSOR element_cur IS
107: SELECT pel.element_type_id
108: FROM pay_element_links_f pel
109: WHERE pel.element_link_id = p_element_link_id_o
110: AND EXISTS (SELECT pee.element_type_id
111: FROM psp_enc_elements pee
112: WHERE pee.element_type_id = pel.element_type_id

Line 184: FROM pay_element_links_f pel

180: l_payroll_id NUMBER DEFAULT NULL;
181:
182: CURSOR element_cur IS
183: SELECT pel.element_type_id
184: FROM pay_element_links_f pel
185: WHERE pel.element_link_id = p_element_link_id_o
186: AND EXISTS (SELECT pee.element_type_id
187: FROM psp_enc_elements pee
188: WHERE pee.element_type_id = pel.element_type_id