APPS.PAY_IE_PAYE_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 94: FROM pay_element_entries_f pee, pay_element_links_f pel, pay_element_types_f pet,pay_element_entry_values_f pev,

90: g_old_payroll_id per_all_assignments_f.payroll_id%TYPE; --added for update_paye_change_freq
91: /* Added cursor for Bug 3030621 */
92: cursor g_absence_dates (c_element_entry_id number) is
93: SELECT pev.SCREEN_ENTRY_VALUE
94: FROM pay_element_entries_f pee, pay_element_links_f pel, pay_element_types_f pet,pay_element_entry_values_f pev,
95: pay_input_values_f piv
96: WHERE pee.element_link_id = pel.element_link_id
97: AND pet.element_type_id = pel.element_type_id
98: AND pet.element_name = 'IE Social Benefit Option 2'

Line 349: PAY_ELEMENT_LINKS_F LINK,

345: select NVL(SUM(TO_NUMBER(SCREEN_ENTRY_VALUE)),0)
346: from
347: PAY_INPUT_VALUES_F INPVAL,
348: PAY_ELEMENT_TYPES_F TYPE,
349: PAY_ELEMENT_LINKS_F LINK,
350: PAY_ELEMENT_ENTRY_VALUES_F VALUE,
351: PAY_ELEMENT_ENTRIES_F ENTRY,
352: PER_TIME_PERIODS PTP,
353: PAY_PAYROLL_ACTIONS PACT