DBA Data[Home] [Help]

APPS.GHR_MLC_PKG dependencies on GHR_LOCALITY_PAY_AREAS_F

Line 48: ghr_locality_pay_areas_f glpa

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

Line 1472: ghr_locality_pay_areas_f glpa

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