DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on HR_LOCATIONS_ALL

Line 1252: * exists in hr_locations. Now select from hr_locations_all

1248:
1249: /* Bug 1904631
1250: * Since location_code for drop ship locations are null in hr_locations,
1251: * max(location_code) will give an incorrect value even if the location_id
1252: * exists in hr_locations. Now select from hr_locations_all
1253: */
1254: BEGIN
1255: SELECT location_id
1256: INTO x_location

Line 1257: FROM hr_locations_all hrl --1942696

1253: */
1254: BEGIN
1255: SELECT location_id
1256: INTO x_location
1257: FROM hr_locations_all hrl --1942696
1258: WHERE ( hrl.inventory_organization_id = x_location_record.to_organization_id
1259: OR NVL(hrl.inventory_organization_id, 0) = 0)
1260: AND ( hrl.inactive_date IS NULL
1261: OR hrl.inactive_date > SYSDATE)