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 207: pay_element_links_f el

203: INDEX(ee pay_element_entries_f_n51) */
204: 'X'
205: FROM pay_element_entries_f ee,
206: pay_element_types_f et,
207: pay_element_links_f el
208: WHERE el.element_link_id = ee.element_link_id
209: AND el.element_link_id = p_element_link_id
210: AND el.element_type_id = et.element_type_id
211: AND ee.assignment_id = p_assignment_id

Line 238: pay_element_links_f el

234: -- Retreive the indirect_only_flag
235: --
236: et.indirect_only_flag
237: FROM pay_element_types_f et,
238: pay_element_links_f el
239: WHERE el.element_link_id = p_element_link_id
240: /* Bug # 8628917. Validating element and link against BG ID*/
241: AND el.business_group_id = l_business_group_id
242: AND el.business_group_id = nvl(et.business_group_id, el.business_group_id)

Line 1464: l_costable_type pay_element_links_f.costable_type%TYPE;

1460: --
1461: -- Bugfix 2646060
1462: -- l_costable_type needed to hold the costable_type of the element link
1463: --
1464: l_costable_type pay_element_links_f.costable_type%TYPE;
1465: --
1466: -- Bugfix 9456999
1467: l_check_for_update varchar2(1);
1468:

Line 1491: , pay_element_links_f el

1487: CURSOR c_link_details ( p_element_entry_id NUMBER
1488: , p_effective_date DATE ) IS
1489: SELECT el.costable_type
1490: FROM pay_element_entries_f ee
1491: , pay_element_links_f el
1492: WHERE ee.element_entry_id = p_element_entry_id
1493: AND ee.element_link_id = el.element_link_id
1494: AND p_effective_date BETWEEN ee.effective_start_date
1495: AND ee.effective_end_date