APPS.OE_OEOL_SCH dependencies on HZ_LOCATIONS

Line 1335: FROM HZ_LOCATIONS LOC,

1331: BEGIN
1332: /* MOAC_SQL_CHANGE */
1333: SELECT LOC.LOCATION_ID
1334: INTO l_deliver_to_location_id
1335: FROM HZ_LOCATIONS LOC,
1336: HZ_PARTY_SITES PARTY,
1337: HZ_CUST_ACCT_SITES ACCT,
1338: HZ_CUST_SITE_USES_ALL CUST
1339: WHERE CUST.SITE_USE_ID=L_LINE_REC.SHIP_TO_ORG_ID