DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on HR_LOCATION_EXTRA_INFO

Line 46: hr_location_extra_info hlei,

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

Line 1470: from hr_location_extra_info hlei,

1466: --
1467:
1468: cursor c_locality (effective_date date,l_loc_id number,l_loc_code varchar2) is
1469: select 1
1470: from hr_location_extra_info hlei,
1471: ghr_duty_stations_f gdsf,
1472: ghr_locality_pay_areas_f glpa
1473: where hlei.location_id = l_loc_id
1474: and hlei.information_type = 'GHR_US_LOC_INFORMATION'