APPS.PER_FR_TERMINATION_UPG_PKG dependencies on HR_LOOKUPS

Line 14: , hr_lookups l

10: p.full_name,
11: pds.date_start
12: FROM per_periods_of_service pds
13: , per_all_people_f p
14: , hr_lookups l
15: WHERE pds.business_group_id = p_business_group_id
16: AND pds.pds_information2 is not null
17: AND pds.leaving_reason is null
18: and l.lookup_type(+) = 'LEAV_REAS'