APPS.GHR_MLC_PKG dependencies on GHR_DUTY_STATIONS_F

Line 47: ghr_duty_stations_f gdsf,

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

Line 1471: ghr_duty_stations_f gdsf,

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

Line 3430: FROM ghr_duty_stations_f

3426:
3427: CURSOR cur_valid_DS(p_ds_id NUMBER)
3428: IS
3429: SELECT effective_end_date end_date
3430: FROM ghr_duty_stations_f
3431: WHERE duty_station_id=p_ds_id
3432: AND g_effective_date between effective_start_date and effective_end_date;
3433:
3434: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

Line 3434: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

3430: FROM ghr_duty_stations_f
3431: WHERE duty_station_id=p_ds_id
3432: AND g_effective_date between effective_start_date and effective_end_date;
3433:
3434: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;
3435:
3436: l_proc varchar2(72) := g_package || '.check_init_eligibility';
3437: BEGIN
3438: