DBA Data[Home] [Help]

APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on PAY_ELEMENT_TYPES_F_TL

Line 2465: pay_element_types_f_tl pettl

2461: cursor c16 is
2462: select pettl.element_name
2463: from per_absence_attendance_types paa,
2464: pay_element_types_f pet,
2465: pay_element_types_f_tl pettl
2466: where pet.element_type_id = p_eletype
2467: and paa.absence_attendance_type_id = p_abat_type
2468: and pet.element_type_id = pettl.element_type_id
2469: and nvl(p_dstart,paa.date_effective)