DBA Data[Home] [Help]

APPS.GHR_SS_VIEWS_PKG dependencies on GHR_DUTY_STATIONS_V

Line 764: GHR_DUTY_STATIONS_F GDS, GHR_LOCALITY_PAY_AREAS_F LPA, GHR_DUTY_STATIONS_V GDSV

760: GDSV.DUTY_STATION_CODE,
761: GDSV.DUTY_STATION_DESC Description, --bug# 9646458
762: GDSV.DUTY_STATION_ID
763: from
764: GHR_DUTY_STATIONS_F GDS, GHR_LOCALITY_PAY_AREAS_F LPA, GHR_DUTY_STATIONS_V GDSV
765: WHERE GDS.DUTY_STATION_ID = GDSV.DUTY_STATION_ID
766: AND GDS.LOCALITY_PAY_AREA_ID = LPA.LOCALITY_PAY_AREA_ID
767: AND p_EFFECTIVE_DATE BETWEEN LPA.EFFECTIVE_START_DATE AND LPA.EFFECTIVE_END_DATE
768: AND p_EFFECTIVE_DATE BETWEEN GDS.EFFECTIVE_START_DATE AND GDS.EFFECTIVE_END_DATE