APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on HR_LOCATIONS

Line 555: FROM HR_LOCATIONS HRL

551: AND NVL(PLI.drop_ship_flag, 'N') <> 'Y' -- cannot add to Drop Ship Shipments
552: AND rtrim(NVL(PLI.note_to_receiver, '99')) = rtrim(NVL(x_note_to_receiver, '99'))
553: AND EXISTS
554: (SELECT 'x'
555: FROM HR_LOCATIONS HRL
556: WHERE PRL.deliver_to_location_id = HRL.location_id
557: AND NVL(HRL.ship_to_location_id, HRL.location_id) = x_ship_to_location_id
558:
559: UNION ALL

Line 645: FROM HR_LOCATIONS HRL

641: AND NVL(PLI.drop_ship_flag, 'N') <> 'Y' -- cannot add to Drop Ship Shipments
642: AND rtrim(NVL(PLI.note_to_receiver, '99')) = rtrim(NVL(x_note_to_receiver, '99'))
643: AND EXISTS
644: (SELECT 'x'
645: FROM HR_LOCATIONS HRL
646: WHERE PRL.deliver_to_location_id = HRL.location_id
647: AND NVL(HRL.ship_to_location_id, HRL.location_id) = x_ship_to_location_id
648:
649: UNION ALL

Line 1942: FROM hr_locations hrl

1938: TO_CHAR ( x_need_by_date - ( TO_NUMBER (SUBSTR (TO_CHAR (x_need_by_date, 'DD-MM-YYYY HH24:MI:SS' ), 18, 2 ) ) / 86400 ), 'DD-MM-YYYY HH24:MI:SS' ) ) ) )
1939: AND ( NVL (l_shipto_prf, 'Y') = 'N'
1940: OR EXISTS
1941: (SELECT 'x'
1942: FROM hr_locations hrl
1943: WHERE prl.deliver_to_location_id = hrl.location_id
1944: AND NVL (hrl.ship_to_location_id, hrl.location_id ) = x_ship_to_location_id
1945:
1946: UNION ALL

Line 2591: FROM hr_locations_all hrl

2587: BEGIN
2588:
2589: SELECT NVL (hrl.ship_to_location_id, hrl.location_id)
2590: INTO l_ship_to_location_id
2591: FROM hr_locations_all hrl
2592: WHERE hrl.location_id = p_deliver_to_loc_id;
2593:
2594: l_found := TRUE;
2595:

Line 2601: po_log.stmt (d_module, d_progress, 'No data found in hr_locations.' );

2597:
2598: WHEN NO_DATA_FOUND THEN
2599:
2600: IF (po_log.d_stmt) THEN
2601: po_log.stmt (d_module, d_progress, 'No data found in hr_locations.' );
2602: END IF;
2603:
2604: END;
2605: