DBA Data[Home] [Help]

APPS.GHR_PAR_BUS dependencies on GHR_DUTY_STATIONS_F

Line 1084: FROM ghr_duty_stations_f dsf

1080: --
1081:
1082: cursor cur_duty_station_id is
1083: SELECT 1
1084: FROM ghr_duty_stations_f dsf
1085: WHERE dsf.duty_station_id = p_duty_station_id;
1086:
1087: cursor cur_duty_station_id_dt is
1088: SELECT 1

Line 1089: FROM ghr_duty_stations_f dsf

1085: WHERE dsf.duty_station_id = p_duty_station_id;
1086:
1087: cursor cur_duty_station_id_dt is
1088: SELECT 1
1089: FROM ghr_duty_stations_f dsf
1090: WHERE dsf.duty_station_id = p_duty_station_id
1091: AND nvl(p_effective_date,sysdate)
1092: BETWEEN dsf.effective_start_date and dsf.effective_end_date;
1093: --