APPS.GHR_MLC_PKG dependencies on GHR_DUTY_STATIONS_F

Line 45: ghr_duty_stations_f gdsf,

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

Line 1445: ghr_duty_stations_f gdsf,

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

Line 3384: FROM ghr_duty_stations_f

3380:
3381: CURSOR cur_valid_DS(p_ds_id NUMBER)
3382: IS
3383: SELECT effective_end_date end_date
3384: FROM ghr_duty_stations_f
3385: WHERE duty_station_id=p_ds_id
3386: AND g_effective_date between effective_start_date and effective_end_date;
3387:
3388: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

Line 3388: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

3384: FROM ghr_duty_stations_f
3385: WHERE duty_station_id=p_ds_id
3386: AND g_effective_date between effective_start_date and effective_end_date;
3387:
3388: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;
3389:
3390: l_proc varchar2(72) := g_package || '.check_init_eligibility';
3391: BEGIN
3392: