APPS.PAY_TEMPLATE_IVS dependencies on PAY_ELEMENT_LINKS_F

Line 94: FROM pay_element_links_f pel

90: Date-effective Element Links that exist for the element type on which
91: the input value is being added:
92: SELECT DISTINCT pel.element_link_id
93: INTO l_element_link_id
94: FROM pay_element_links_f pel
95: WHERE pel.element_type_id = p_element_type_id
96: ORDER BY pel.effective_start_date;
97:
98:

Line 102: FROM pay_element_links_f pel

98:
99: 1b. For each element link id found in 1a, find the min start and max end date.
100: SELECT min(pel.effective_start_date)
101: INTO l_link_eff_start
102: FROM pay_element_links_f pel
103: WHERE pel.element_link_id = l_element_link_id;
104:
105: SELECT max(pel.effective_end_date)
106: INTO l_link_eff_end

Line 107: FROM pay_element_links_f pel

103: WHERE pel.element_link_id = l_element_link_id;
104:
105: SELECT max(pel.effective_end_date)
106: INTO l_link_eff_end
107: FROM pay_element_links_f pel
108: WHERE pel.element_link_id = l_element_link_id;
109:
110:
111: 1c. Then create appropriately date-effective link input value row...

Line 230: FROM pay_element_links_f pel

226: entryval_exists number;
227:
228: CURSOR get_links (p_ele_id NUMBER) IS
229: SELECT pel.element_link_id
230: FROM pay_element_links_f pel
231: WHERE pel.element_type_id = p_ele_id
232: ORDER BY pel.effective_start_date;
233:
234: CURSOR get_entries (p_link_id NUMBER) IS

Line 276: FROM pay_element_links_f pel

272: EXIT WHEN get_links%NOTFOUND;
273:
274: SELECT min(pel.effective_start_date)
275: INTO l_link_eff_start
276: FROM pay_element_links_f pel
277: WHERE pel.element_link_id = l_element_link_id;
278:
279: SELECT max(pel.effective_end_date)
280: INTO l_link_eff_end

Line 281: FROM pay_element_links_f pel

277: WHERE pel.element_link_id = l_element_link_id;
278:
279: SELECT max(pel.effective_end_date)
280: INTO l_link_eff_end
281: FROM pay_element_links_f pel
282: WHERE pel.element_link_id = l_element_link_id;
283:
284: /*
285: 1c. Then create appropriately date-effective link input value row...

Line 680: from pay_element_links_f el,

676: into v_validation_check
677: from sys.dual
678: where exists
679: (select 1
680: from pay_element_links_f el,
681: pay_element_entries_f ee
682: where p_element_type_id = el.element_type_id
683: and el.element_link_id = ee.element_link_id
684: and ee.effective_end_date >= p_val_start_date