DBA Data[Home] [Help]

APPS.PO_LOCATIONS_S dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 242: org_organization_definitions ood

238:
239: SELECT hrl.inventory_organization_id
240: INTO x_org_id
241: FROM hr_locations hrl,
242: org_organization_definitions ood
243: WHERE ood.organization_id = hrl.inventory_organization_id
244: AND ood.set_of_books_id = x_sob_id
245: AND hrl.location_id = x_location_id;
246:

Line 253: FROM org_organization_definitions ood

249: SELECT ood.organization_name,
250: ood.organization_code
251: INTO x_org_name,
252: X_org_code
253: FROM org_organization_definitions ood
254: WHERE ood.organization_id = x_org_id;
255:
256: exception
257: when no_data_found then