APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on HR_LOCATIONS_ALL

Line 103: --bug 6770323: modified cursor to join with hr_locations_all table

99: )
100: AND WDL.DELIVERY_ID = WND.DELIVERY_ID
101: AND HOU.ORGANIZATION_ID = WND.ORGANIZATION_ID;
102:
103: --bug 6770323: modified cursor to join with hr_locations_all table
104: cursor l_stop_org_csr(p_stop_id IN NUMBER) is
105: SELECT HL.INVENTORY_ORGANIZATION_ID
106: FROM HR_LOCATIONS_ALL HL,
107: WSH_LOCATIONS WL,

Line 106: FROM HR_LOCATIONS_ALL HL,

102:
103: --bug 6770323: modified cursor to join with hr_locations_all table
104: cursor l_stop_org_csr(p_stop_id IN NUMBER) is
105: SELECT HL.INVENTORY_ORGANIZATION_ID
106: FROM HR_LOCATIONS_ALL HL,
107: WSH_LOCATIONS WL,
108: WSH_TRIP_STOPS WTS
109: WHERE WTS.STOP_ID = p_stop_id
110: AND HL.LOCATION_ID = WL.SOURCE_LOCATION_ID

Line 336: --bug 6770323: modified cursor to join with hr_locations_all table

332: AND LOCATION_ID = p_location_id
333: AND CORPORATION_ID = p_corporation_id
334: AND LOCATION_TYPE = 'CUST_LOC';
335:
336: --bug 6770323: modified cursor to join with hr_locations_all table
337: cursor l_loc_to_org_csr (p_loc_id NUMBER) IS
338: SELECT inventory_organization_id
339: FROM hr_locations_all
340: WHERE location_id = p_loc_id;

Line 339: FROM hr_locations_all

335:
336: --bug 6770323: modified cursor to join with hr_locations_all table
337: cursor l_loc_to_org_csr (p_loc_id NUMBER) IS
338: SELECT inventory_organization_id
339: FROM hr_locations_all
340: WHERE location_id = p_loc_id;
341:
342: cursor l_check_loc_exists_csr (p_location_id IN NUMBER,
343: p_corporation_id IN NUMBER

Line 1407: from HR_LOCATIONS_ALL HRL,

1403: ORG.ORGANIZATION_ID,
1404: GREATEST(HRL.LAST_UPDATE_DATE,
1405: nvl(ORG.LAST_UPDATE_DATE, to_date('1900/01/01 00:00:01', 'YYYY/MM/DD HH24:MI:SS'))
1406: ) LAST_UPDATE_DATE
1407: from HR_LOCATIONS_ALL HRL,
1408: HR_ALL_ORGANIZATION_UNITS ORG,
1409: --HR_ALL_ORGANIZATION_UNITS_TL ORGL,
1410: --FND_LANGUAGES FNDL,
1411: FND_TERRITORIES FNDTR,

Line 3102: --bug 6770323: modified cursor to join with hr_locations_all table

3098: l_return_status VARCHAR2(10);
3099: l_num_errors NUMBER;
3100: l_num_warnings NUMBER;
3101:
3102: --bug 6770323: modified cursor to join with hr_locations_all table
3103: cursor l_loc_to_org_csr (p_loc_id NUMBER) IS
3104: SELECT inventory_organization_id
3105: FROM hr_locations_all
3106: WHERE location_id = p_loc_id;

Line 3105: FROM hr_locations_all

3101:
3102: --bug 6770323: modified cursor to join with hr_locations_all table
3103: cursor l_loc_to_org_csr (p_loc_id NUMBER) IS
3104: SELECT inventory_organization_id
3105: FROM hr_locations_all
3106: WHERE location_id = p_loc_id;
3107:
3108: --
3109: l_debug_on BOOLEAN;