APPS.RCV_RMA_TRANSACTIONS dependencies on HR_LOCATIONS

Line 838: FROM hr_locations hl,

834:
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:

Line 849: FROM hr_locations hl,

845: END IF;
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:

Line 3448: FROM hr_locations

3444: ) IS
3445: BEGIN
3446: SELECT MAX(location_id)
3447: INTO x_location_id_record.location_id
3448: FROM hr_locations
3449: WHERE location_code = x_location_id_record.location_code;
3450:
3451: IF (x_location_id_record.location_id IS NULL) THEN
3452: x_location_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

Line 3646: FROM hr_locations

3642: ) IS
3643: BEGIN
3644: SELECT inventory_organization_id
3645: INTO x_organization_id
3646: FROM hr_locations
3647: WHERE location_id = p_hr_location_id;
3648: EXCEPTION
3649: WHEN OTHERS THEN
3650: x_organization_id := NULL;