APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PO_UN_NUMBERS_VL

Line 4756: FROM po_un_numbers_vl

4752: INSERT INTO po_session_gt(key, num1, num2)
4753: SELECT p_key,
4754: p_index_tbl(i),
4755: un_number_id
4756: FROM po_un_numbers_vl
4757: WHERE p_un_number_tbl(i) IS NOT NULL
4758: AND x_un_number_id_tbl(i) IS NULL
4759: AND sysdate < nvl(inactive_date, sysdate +1)
4760: AND un_number = p_un_number_tbl(i);

Line 5663: FROM po_un_numbers_vl

5659: INSERT INTO po_session_gt(key, num1, num2)
5660: SELECT p_key,
5661: p_index_tbl(i),
5662: hazard_class_id
5663: FROM po_un_numbers_vl
5664: WHERE p_un_number_tbl(i) IS NOT NULL
5665: AND x_hazard_class_id_tbl(i) IS NULL
5666: AND sysdate < nvl(inactive_date, sysdate +1)
5667: AND un_number = p_un_number_tbl(i);