APPS.PO_INTERFACE_S dependencies on HR_LOCATIONS_ALL

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

1787:
1788: l_progress:= '190';
1789: --bug 4229954
1790: --we will validate a location based on Bill-To-Location and Ship-To-Location flags
1791: --of hr_locations_all along with inactive date check
1792: BEGIN
1793: select 'Y' into x_is_valid
1794: from hr_locations_all
1795: where location_id = x_valid_ship_to

Line 1794: from hr_locations_all

1790: --we will validate a location based on Bill-To-Location and Ship-To-Location flags
1791: --of hr_locations_all along with inactive date check
1792: BEGIN
1793: select 'Y' into x_is_valid
1794: from hr_locations_all
1795: where location_id = x_valid_ship_to
1796: and NVL(ship_to_site_flag, 'N') = 'Y' --bug 4229954
1797: and NVL(trunc(inactive_date),trunc(SYSDATE)+1) > trunc(SYSDATE);
1798:

Line 1821: from hr_locations_all

1817:
1818: l_progress:= '200';
1819: BEGIN
1820: select 'Y' into x_is_valid
1821: from hr_locations_all
1822: where location_id = x_valid_bill_to
1823: and NVL(bill_to_site_flag, 'N') = 'Y' --bug 4229954
1824: and NVL(trunc(inactive_date),trunc(SYSDATE)+1) > trunc(SYSDATE);
1825:

Line 8708: l_ship_to_org_id HR_LOCATIONS_ALL.inventory_organization_id%TYPE;

8704: -- in case of non req back lines from sourcing , ship_to_organization_id is NULL.
8705: -- so get it from distribution interface table.
8706:
8707: --
8708: l_ship_to_org_id HR_LOCATIONS_ALL.inventory_organization_id%TYPE;
8709: --
8710:
8711: BEGIN
8712: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 9642: FROM hr_locations_all hrl

9638: -- SQL WHY: the ship_to_organization is optional from sourcing
9639: BEGIN
9640: SELECT hrl.inventory_organization_id
9641: INTO l_ship_to_org_id
9642: FROM hr_locations_all hrl
9643: WHERE hrl.location_id = i.ship_to_location_id
9644: AND hrl.ship_to_site_flag = 'Y';
9645: EXCEPTION
9646: WHEN no_data_found THEN