APPS.GHR_CPDF_STATRPT dependencies on HR_LOCATION_EXTRA_INFO

Line 699: FROM HR_LOCATION_EXTRA_INFO

695: WHERE trunc(p_sr_report_date) between effective_start_date and
696: nvl(effective_end_date, p_sr_report_date)
697: AND DUTY_STATION_ID =
698: (SELECT LEI_INFORMATION3
699: FROM HR_LOCATION_EXTRA_INFO
700: WHERE INFORMATION_TYPE = 'GHR_US_LOC_INFORMATION'
701: AND LOCATION_ID = g_location_id);
702:
703: -- Declared record despite a "one column query" for future maintenance

Line 908: FROM HR_LOCATION_EXTRA_INFO

904: WHERE trunc(p_report_date) between effective_start_date and
905: nvl(effective_end_date, p_report_date)
906: AND DUTY_STATION_ID =
907: (SELECT LEI_INFORMATION3
908: FROM HR_LOCATION_EXTRA_INFO
909: WHERE INFORMATION_TYPE = 'GHR_US_LOC_INFORMATION'
910: AND LOCATION_ID = g_location_id);
911:
912: l_STATE_CNTRY_CODE GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;