APPS.RCV_RMA_TRANSACTIONS dependencies on HR_LOCATIONS

Line 837: FROM hr_locations hl,

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

Line 848: FROM hr_locations hl,

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

Line 3308: FROM hr_locations

3304: ) IS
3305: BEGIN
3306: SELECT MAX(location_id)
3307: INTO x_location_id_record.location_id
3308: FROM hr_locations
3309: WHERE location_code = x_location_id_record.location_code;
3310:
3311: IF (x_location_id_record.location_id IS NULL) THEN
3312: x_location_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

Line 3506: FROM hr_locations

3502: ) IS
3503: BEGIN
3504: SELECT inventory_organization_id
3505: INTO x_organization_id
3506: FROM hr_locations
3507: WHERE location_id = p_hr_location_id;
3508: EXCEPTION
3509: WHEN OTHERS THEN
3510: x_organization_id := NULL;