APPS.PAY_ELEMENT_ENTRY_API dependencies on PAY_ELEMENT_LINKS_F

Line 168: l_costable_type pay_element_links_f.costable_type%TYPE;

164: --
165: -- Bugfix 2646060
166: -- l_costable_type needed to hold the costable_type of the element link
167: --
168: l_costable_type pay_element_links_f.costable_type%TYPE;
169: --
170: -- Bugfix 3079267
171: -- l_indirect_only_flag required to hold indirect_only_flag value of the
172: -- element link

Line 199: pay_element_links_f el

195: INDEX(ee pay_element_entries_f_n51) */
196: 'X'
197: FROM pay_element_entries_f ee,
198: pay_element_types_f et,
199: pay_element_links_f el
200: WHERE el.element_link_id = ee.element_link_id
201: AND el.element_link_id = p_element_link_id
202: AND el.element_type_id = et.element_type_id
203: AND ee.assignment_id = p_assignment_id

Line 229: pay_element_links_f el

225: -- Retreive the indirect_only_flag
226: --
227: et.indirect_only_flag
228: FROM pay_element_types_f et,
229: pay_element_links_f el
230: WHERE el.element_link_id = p_element_link_id
231: AND el.element_type_id = et.element_type_id
232: AND l_effective_date BETWEEN el.effective_start_date
233: AND el.effective_end_date

Line 1440: l_costable_type pay_element_links_f.costable_type%TYPE;

1436: --
1437: -- Bugfix 2646060
1438: -- l_costable_type needed to hold the costable_type of the element link
1439: --
1440: l_costable_type pay_element_links_f.costable_type%TYPE;
1441: --
1442: CURSOR c_output_variables IS
1443: SELECT ee.effective_start_date,
1444: ee.effective_end_date,

Line 1464: , pay_element_links_f el

1460: CURSOR c_link_details ( p_element_entry_id NUMBER
1461: , p_effective_date DATE ) IS
1462: SELECT el.costable_type
1463: FROM pay_element_entries_f ee
1464: , pay_element_links_f el
1465: WHERE ee.element_entry_id = p_element_entry_id
1466: AND ee.element_link_id = el.element_link_id
1467: AND p_effective_date BETWEEN ee.effective_start_date
1468: AND ee.effective_end_date