APPS.PAY_GB_TAX_CREDIT_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 51: l_element_link_id PAY_ELEMENT_LINKS_F.ELEMENT_LINK_ID%TYPE;

47: select element_type_id
48: from pay_element_types
49: where element_name = 'Tax Credit';
50:
51: l_element_link_id PAY_ELEMENT_LINKS_F.ELEMENT_LINK_ID%TYPE;
52: l_element_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
53: l_create_warning BOOLEAN;
54: l_effective_date DATE;
55:

Line 99: pay_element_links_f lnk,

95: pay_element_entries_f ent,
96: pay_input_values_f ipv1,
97: pay_input_values_f ipv2,
98: pay_input_values_f ipv3,
99: pay_element_links_f lnk,
100: pay_element_types_f ele
101: where ele.element_name = p_ele
102: and ele.element_type_id = lnk.element_type_id
103: and ent.element_link_id = lnk.element_link_id

Line 154: pay_element_links_f lnk,

150: pay_element_entry_values_f eev2,
151: pay_element_entries_f ent,
152: pay_input_values_f ipv1,
153: pay_input_values_f ipv2,
154: pay_element_links_f lnk,
155: pay_element_types_f ele
156: where ele.element_name = p_ele
157: and ele.element_type_id = lnk.element_type_id
158: and ent.element_link_id = lnk.element_link_id

Line 186: pay_element_links_f lnk,

182: pay_element_entries_f ent,
183: pay_input_values_f ipv1,
184: pay_input_values_f ipv2,
185: pay_input_values_f ipv3,
186: pay_element_links_f lnk,
187: pay_element_types_f ele
188: where ele.element_name = p_ele
189: and ele.element_type_id = lnk.element_type_id
190: and ent.element_link_id = lnk.element_link_id

Line 222: pay_element_links_f lnk,

218: pay_element_entry_values_f eev2,
219: pay_element_entries_f ent,
220: pay_input_values_f ipv1,
221: pay_input_values_f ipv2,
222: pay_element_links_f lnk,
223: pay_element_types_f ele
224: where ele.element_name = p_ele
225: and ele.element_type_id = lnk.element_type_id
226: and ent.element_link_id = lnk.element_link_id

Line 455: pay_element_links_f lnk,

451: pay_element_entries_f ent,
452: pay_input_values_f ipv1,
453: pay_input_values_f ipv2,
454: pay_input_values_f ipv3,
455: pay_element_links_f lnk,
456: pay_element_types_f ele
457: where ele.element_name = p_ele
458: and ele.element_type_id = lnk.element_type_id
459: and ent.element_link_id = lnk.element_link_id