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 366: --bug 6770323: modified cursor to join with hr_locations_all table

362: AND LOCATION_ID = p_location_id
363: AND CORPORATION_ID = p_corporation_id
364: AND LOCATION_TYPE = 'CUST_LOC';
365:
366: --bug 6770323: modified cursor to join with hr_locations_all table
367: cursor l_loc_to_org_csr (p_loc_id NUMBER) IS
368: SELECT inventory_organization_id
369: FROM hr_locations_all
370: WHERE location_id = p_loc_id;

Line 369: FROM hr_locations_all

365:
366: --bug 6770323: modified cursor to join with hr_locations_all table
367: cursor l_loc_to_org_csr (p_loc_id NUMBER) IS
368: SELECT inventory_organization_id
369: FROM hr_locations_all
370: WHERE location_id = p_loc_id;
371:
372: cursor l_check_loc_exists_csr (p_location_id IN NUMBER,
373: p_corporation_id IN NUMBER

Line 1446: from HR_LOCATIONS_ALL HRL,

1442: ORG.ORGANIZATION_ID,
1443: GREATEST(HRL.LAST_UPDATE_DATE,
1444: nvl(ORG.LAST_UPDATE_DATE, to_date('1900/01/01 00:00:01', 'YYYY/MM/DD HH24:MI:SS'))
1445: ) LAST_UPDATE_DATE
1446: from HR_LOCATIONS_ALL HRL,
1447: HR_ALL_ORGANIZATION_UNITS ORG,
1448: --HR_ALL_ORGANIZATION_UNITS_TL ORGL,
1449: --FND_LANGUAGES FNDL,
1450: FND_TERRITORIES FNDTR,

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

3137: l_return_status VARCHAR2(10);
3138: l_num_errors NUMBER;
3139: l_num_warnings NUMBER;
3140:
3141: --bug 6770323: modified cursor to join with hr_locations_all table
3142: cursor l_loc_to_org_csr (p_loc_id NUMBER) IS
3143: SELECT inventory_organization_id
3144: FROM hr_locations_all
3145: WHERE location_id = p_loc_id;

Line 3144: FROM hr_locations_all

3140:
3141: --bug 6770323: modified cursor to join with hr_locations_all table
3142: cursor l_loc_to_org_csr (p_loc_id NUMBER) IS
3143: SELECT inventory_organization_id
3144: FROM hr_locations_all
3145: WHERE location_id = p_loc_id;
3146:
3147: --
3148: l_debug_on BOOLEAN;