APPS.QA_ERES_PKG dependencies on PO_UN_NUMBERS_VL

Line 238: FROM PO_UN_NUMBERS_VL

234: rt.po_line_id = POL.PO_LINE_ID(+);
235:
236: CURSOR C2 (p_un_number_id NUMBER) IS
237: SELECT UN_NUMBER
238: FROM PO_UN_NUMBERS_VL
239: WHERE UN_NUMBER_ID = p_un_number_id;
240:
241: l_un_number_id NUMBER;
242: l_un_number PO_UN_NUMBERS_VL.UN_NUMBER%TYPE;

Line 242: l_un_number PO_UN_NUMBERS_VL.UN_NUMBER%TYPE;

238: FROM PO_UN_NUMBERS_VL
239: WHERE UN_NUMBER_ID = p_un_number_id;
240:
241: l_un_number_id NUMBER;
242: l_un_number PO_UN_NUMBERS_VL.UN_NUMBER%TYPE;
243: BEGIN
244: OPEN C1;
245: FETCH C1 INTO l_un_number_id;
246: IF C1%NOTFOUND OR l_un_number_id IS NULL THEN