APPS.PAY_BAL_ADJUST dependencies on PAY_ELEMENT_LINKS_F

Line 548: l_costable_type pay_element_links_f.costable_type%TYPE;

544: --
545: -- Bugfix 2665492
546: -- l_costable_type needed to hold the costable_type of the element link
547: --
548: l_costable_type pay_element_links_f.costable_type%TYPE;
549: --
550: CURSOR c_output_variables IS
551: SELECT ee.object_version_number
552: FROM pay_element_entries_f ee

Line 573: pay_element_links_f el

569: CURSOR c_entry_exists IS
570: SELECT 'X'
571: FROM pay_element_entries_f ee,
572: pay_element_types_f et,
573: pay_element_links_f el
574: WHERE el.element_link_id = ee.element_link_id
575: AND el.element_link_id = p_element_link_id
576: AND el.element_type_id = et.element_type_id
577: AND ee.assignment_id = p_assignment_id

Line 598: pay_element_links_f el

594: -- Retrieve the element_link costable_type
595: --
596: el.costable_type
597: FROM pay_element_types_f et,
598: pay_element_links_f el
599: WHERE el.element_link_id = p_element_link_id
600: AND el.element_type_id = et.element_type_id
601: AND l_effective_date BETWEEN el.effective_start_date
602: AND el.effective_end_date