DBA Data[Home] [Help]

APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 2300: pay_element_types_f t,

2296: l.element_link_id,
2297: asg.payroll_id,
2298: 'X'
2299: from per_assignments_f asg,
2300: pay_element_types_f t,
2301: pay_element_links_f l
2302: where l.business_group_id + 0 = p_bgroup_id
2303: and t.element_type_id = p_eltype
2304: and asg.person_id = p_per_id

Line 2360: pay_element_types_f pet,

2356:
2357: cursor c16 is
2358: select pettl.element_name
2359: from per_absence_attendance_types paa,
2360: pay_element_types_f pet,
2361: pay_element_types_f_tl pettl
2362: where pet.element_type_id = p_eletype
2363: and paa.absence_attendance_type_id = p_abat_type
2364: and pet.element_type_id = pettl.element_type_id

Line 2361: pay_element_types_f_tl pettl

2357: cursor c16 is
2358: select pettl.element_name
2359: from per_absence_attendance_types paa,
2360: pay_element_types_f pet,
2361: pay_element_types_f_tl pettl
2362: where pet.element_type_id = p_eletype
2363: and paa.absence_attendance_type_id = p_abat_type
2364: and pet.element_type_id = pettl.element_type_id
2365: and nvl(p_dstart,paa.date_effective)