APPS.RCV_RMA_TRANSACTIONS dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 839: HR_ALL_ORGANIZATION_UNITS org --Bug 5217526. Earlier used org_organization_definitions

835: IF (x_cascaded_table(n).ship_to_location_id IS NOT NULL) THEN
836: SELECT MAX(org.organization_id)
837: INTO x_cascaded_table(n).to_organization_code
838: FROM hr_locations hl,
839: HR_ALL_ORGANIZATION_UNITS org --Bug 5217526. Earlier used org_organization_definitions
840: WHERE x_cascaded_table(n).ship_to_location_id = hl.location_id
841: AND hl.inventory_organization_id = org.organization_id;
842:
843: IF (g_asn_debug = 'Y') THEN

Line 850: HR_ALL_ORGANIZATION_UNITS org --Bug 5217526. Earlier used org_organization_definitions

846: ELSIF(x_cascaded_table(n).ship_to_location_code IS NOT NULL) THEN
847: SELECT MAX(org.organization_id)
848: INTO x_cascaded_table(n).to_organization_code
849: FROM hr_locations hl,
850: HR_ALL_ORGANIZATION_UNITS org --Bug 5217526. Earlier used org_organization_definitions
851: WHERE x_cascaded_table(n).ship_to_location_code = hl.location_code
852: AND hl.inventory_organization_id = org.organization_id;
853:
854: IF (g_asn_debug = 'Y') THEN

Line 2589: FROM org_organization_definitions

2585: --rather than based on context.
2586: BEGIN
2587: select set_of_books_id
2588: into x_sob_id
2589: FROM org_organization_definitions
2590: WHERE organization_id = x_cascaded_table(n).to_organization_id ;
2591: EXCEPTION
2592: WHEN NO_DATA_FOUND THEN
2593: IF (g_asn_debug = 'Y') THEN