APPS.QP_QPXPRMLS_XMLP_PKG dependencies on OE_BLANKET_HEADERS_ALL

Line 413: OE_BLANKET_HEADERS_ALL

409: SELECT
410: ORDER_NUMBER
411: INTO L_QUALIFIER_ATTR_VALUE
412: FROM
413: OE_BLANKET_HEADERS_ALL
414: WHERE HEADER_ID = QUALIFIER_ATTR_VALUE;
415: EXCEPTION
416: WHEN OTHERS THEN
417: NULL;

Line 425: OE_BLANKET_HEADERS_ALL H,

421: SELECT
422: H.ORDER_NUMBER || '-' || L.LINE_NUMBER
423: INTO L_QUALIFIER_ATTR_VALUE
424: FROM
425: OE_BLANKET_HEADERS_ALL H,
426: OE_BLANKET_LINES_ALL L
427: WHERE L.LINE_ID = QUALIFIER_ATTR_VALUE
428: AND H.HEADER_ID = L.HEADER_ID;
429: EXCEPTION

Line 466: OE_BLANKET_HEADERS_ALL

462: SELECT
463: ORDER_NUMBER
464: INTO L_QUALIFIER_ATTR_VALUE_TO
465: FROM
466: OE_BLANKET_HEADERS_ALL
467: WHERE HEADER_ID = QUALIFIER_ATTR_VALUE_TO;
468: EXCEPTION
469: WHEN OTHERS THEN
470: NULL;

Line 478: OE_BLANKET_HEADERS_ALL H,

474: SELECT
475: H.ORDER_NUMBER || '-' || L.LINE_NUMBER
476: INTO L_QUALIFIER_ATTR_VALUE_TO
477: FROM
478: OE_BLANKET_HEADERS_ALL H,
479: OE_BLANKET_LINES_ALL L
480: WHERE L.LINE_ID = QUALIFIER_ATTR_VALUE_TO
481: AND H.HEADER_ID = L.HEADER_ID;
482: EXCEPTION