DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on HR_LOCATION_EXTRA_INFO

Line 44: hr_location_extra_info hlei,

40: from per_assignments_f paf,
41: per_people_f ppf,
42: per_person_types ppt,
43: per_assignment_status_types pas_t,
44: hr_location_extra_info hlei,
45: ghr_duty_stations_f gdsf,
46: ghr_locality_pay_areas_f glpa
47: where ppf.person_id = paf.person_id
48: and paf.primary_flag = 'Y'

Line 1444: from hr_location_extra_info hlei,

1440: --
1441:
1442: cursor c_locality (effective_date date,l_loc_id number,l_loc_code varchar2) is
1443: select 1
1444: from hr_location_extra_info hlei,
1445: ghr_duty_stations_f gdsf,
1446: ghr_locality_pay_areas_f glpa
1447: where hlei.location_id = l_loc_id
1448: and hlei.information_type = 'GHR_US_LOC_INFORMATION'