APPS.PAY_IE_PAYE_PKG dependencies on PAY_ELEMENT_TYPES_F

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

80: g_old_payroll_id per_all_assignments_f.payroll_id%TYPE; --added for update_paye_change_freq
81: /* Added cursor for Bug 3030621 */
82: cursor g_absence_dates (c_element_entry_id number) is
83: SELECT pev.SCREEN_ENTRY_VALUE
84: FROM pay_element_entries_f pee, pay_element_links_f pel, pay_element_types_f pet,pay_element_entry_values_f pev,
85: pay_input_values_f piv
86: WHERE pee.element_link_id = pel.element_link_id
87: AND pet.element_type_id = pel.element_type_id
88: AND pet.element_name = 'IE Social Benefit Option 2'

Line 338: PAY_ELEMENT_TYPES_F TYPE,

334: is
335: select NVL(SUM(TO_NUMBER(SCREEN_ENTRY_VALUE)),0)
336: from
337: PAY_INPUT_VALUES_F INPVAL,
338: PAY_ELEMENT_TYPES_F TYPE,
339: PAY_ELEMENT_LINKS_F LINK,
340: PAY_ELEMENT_ENTRY_VALUES_F VALUE,
341: PAY_ELEMENT_ENTRIES_F ENTRY,
342: PER_TIME_PERIODS PTP,