DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on GHR_LOCALITY_PAY_AREAS_F

Line 46: ghr_locality_pay_areas_f glpa

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'
49: and paf.assignment_type <> 'B'
50: and paf.assignment_status_type_id = pas_t.assignment_status_type_id

Line 1446: ghr_locality_pay_areas_f glpa

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'
1449: and hlei.lei_information3 = gdsf.duty_station_id
1450: and gdsf.locality_pay_area_id = glpa.locality_pay_area_id