APPS.RCV_CORE_S dependencies on HR_LOCATIONS

Line 108: FROM hr_locations

104: x_progress := '040';
105:
106: SELECT location_code
107: INTO x_ship_to_loc_code
108: FROM hr_locations
109: WHERE NVL(inventory_organization_id, x_org_id) = x_org_id
110: AND ( inactive_date IS NULL
111: OR inactive_date > x_trx_date)
112: AND location_id = ship_to_loc_id;

Line 127: FROM hr_locations

123: x_progress := '050';
124:
125: SELECT location_code
126: INTO x_deliver_to_loc_code
127: FROM hr_locations
128: WHERE NVL(inventory_organization_id, x_org_id) = x_org_id
129: AND ( inactive_date IS NULL
130: OR inactive_date > x_trx_date)
131: AND location_id = deliver_to_loc_id;