APPS.GHR_CPDF_EHRIS dependencies on HR_LOCATION_EXTRA_INFO

Line 1311: FROM HR_LOCATION_EXTRA_INFO

1307: WHERE trunc(p_sr_report_date) between effective_start_date and
1308: nvl(effective_end_date, p_sr_report_date)
1309: AND DUTY_STATION_ID =
1310: (SELECT LEI_INFORMATION3
1311: FROM HR_LOCATION_EXTRA_INFO
1312: WHERE INFORMATION_TYPE = 'GHR_US_LOC_INFORMATION'
1313: AND LOCATION_ID = g_location_id);
1314:
1315: -- Declared record despite a "one column query" for future maintenance

Line 1750: FROM HR_LOCATION_EXTRA_INFO

1746: WHERE trunc(p_report_date) between effective_start_date and
1747: nvl(effective_end_date, p_report_date)
1748: AND DUTY_STATION_ID =
1749: (SELECT LEI_INFORMATION3
1750: FROM HR_LOCATION_EXTRA_INFO
1751: WHERE INFORMATION_TYPE = 'GHR_US_LOC_INFORMATION'
1752: AND LOCATION_ID = g_location_id);
1753:
1754: l_STATE_CNTRY_CODE GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;