DBA Data[Home] [Help]

APPS.OKE_DTS_INTEGRATION_PKG dependencies on HR_LOCATIONS_ALL_TL

Line 1799: , hr_locations_all_tl L

1795: CURSOR c_ship (p_id number) IS
1796: SELECT D.ship_from_location_id
1797: , L.location_code ship_from_location
1798: FROM oke_k_deliverables_b D
1799: , hr_locations_all_tl L
1800: WHERE D.deliverable_id = p_id
1801: AND L.location_id = D.ship_from_location_id
1802: AND L.language = userenv('LANG');
1803: -- srec c_ship%rowtype;