APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on PO_UN_NUMBERS_VL

Line 5678: FROM po_un_numbers_vl

5674: INSERT INTO po_session_gt(key, num1, num2)
5675: SELECT p_key,
5676: p_index_tbl(i),
5677: un_number_id
5678: FROM po_un_numbers_vl
5679: WHERE p_un_number_tbl(i) IS NOT NULL
5680: AND x_un_number_id_tbl(i) IS NULL
5681: AND sysdate < nvl(inactive_date, sysdate +1)
5682: AND un_number = p_un_number_tbl(i);

Line 6585: FROM po_un_numbers_vl

6581: INSERT INTO po_session_gt(key, num1, num2)
6582: SELECT p_key,
6583: p_index_tbl(i),
6584: hazard_class_id
6585: FROM po_un_numbers_vl
6586: WHERE p_un_number_tbl(i) IS NOT NULL
6587: AND x_hazard_class_id_tbl(i) IS NULL
6588: AND sysdate < nvl(inactive_date, sysdate +1)
6589: AND un_number = p_un_number_tbl(i);