APPS.PO_INTERFACE_S dependencies on HR_LOCATIONS_ALL

Line 2075: --of hr_locations_all along with inactive date check

2071:
2072: l_progress:= '190';
2073: --bug 4229954
2074: --we will validate a location based on Bill-To-Location and Ship-To-Location flags
2075: --of hr_locations_all along with inactive date check
2076: BEGIN
2077: select 'Y' into x_is_valid
2078: from hr_locations_all
2079: where location_id = x_valid_ship_to

Line 2078: from hr_locations_all

2074: --we will validate a location based on Bill-To-Location and Ship-To-Location flags
2075: --of hr_locations_all along with inactive date check
2076: BEGIN
2077: select 'Y' into x_is_valid
2078: from hr_locations_all
2079: where location_id = x_valid_ship_to
2080: and NVL(ship_to_site_flag, 'N') = 'Y' --bug 4229954
2081: and NVL(trunc(inactive_date),trunc(SYSDATE)+1) > trunc(SYSDATE);
2082:

Line 2105: from hr_locations_all

2101:
2102: l_progress:= '200';
2103: BEGIN
2104: select 'Y' into x_is_valid
2105: from hr_locations_all
2106: where location_id = x_valid_bill_to
2107: and NVL(bill_to_site_flag, 'N') = 'Y' --bug 4229954
2108: and NVL(trunc(inactive_date),trunc(SYSDATE)+1) > trunc(SYSDATE);
2109:

Line 9326: l_ship_to_org_id HR_LOCATIONS_ALL.inventory_organization_id%TYPE;

9322: -- in case of non req back lines from sourcing , ship_to_organization_id is NULL.
9323: -- so get it from distribution interface table.
9324:
9325: --
9326: l_ship_to_org_id HR_LOCATIONS_ALL.inventory_organization_id%TYPE;
9327: --
9328:
9329: BEGIN
9330: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 10272: FROM hr_locations_all hrl

10268: -- SQL WHY: the ship_to_organization is optional from sourcing
10269: BEGIN
10270: SELECT hrl.inventory_organization_id
10271: INTO l_ship_to_org_id
10272: FROM hr_locations_all hrl
10273: WHERE hrl.location_id = i.ship_to_location_id
10274: AND hrl.ship_to_site_flag = 'Y';
10275: EXCEPTION
10276: WHEN no_data_found THEN

Line 14403: FROM hr_locations_all hrl--bug 8763609

14399: views , we need to use _all tables to get the ship to location id. */
14400:
14401: SELECT NVL(hrl.ship_to_location_id, hrl.location_id)
14402: INTO l_ship_to_location_id
14403: FROM hr_locations_all hrl--bug 8763609
14404: WHERE hrl.location_id = p_deliver_to_loc_id;
14405:
14406: l_found := TRUE;
14407: