APPS.OM_SETUP_VALID_PKG dependencies on QP_LIST_HEADERS_B

Line 2575: FROM QP_LIST_LINES_V QLLV, QP_LIST_HEADERS_B QLHB

2571: errLogged BOOLEAN;
2572: BEGIN
2573: SELECT COUNT(QLLV.LIST_HEADER_ID)
2574: INTO prclstct
2575: FROM QP_LIST_LINES_V QLLV, QP_LIST_HEADERS_B QLHB
2576: WHERE QLLV.LIST_HEADER_ID = QLHB.LIST_HEADER_ID
2577: /* Commented as it is not required.
2578: AND SYSDATE >= NVL(QLHB.START_DATE_ACTIVE, TO_DATE('01-JAN-1000','DD-MON-YYYY'))
2579: AND SYSDATE < NVL(QLHB.END_DATE_ACTIVE, TO_DATE('31-DEC-2999'))

Line 2583: FROM QP_LIST_HEADERS_B);

2579: AND SYSDATE < NVL(QLHB.END_DATE_ACTIVE, TO_DATE('31-DEC-2999'))
2580: */
2581: AND QLLV.PRODUCT_ATTRIBUTE = 'PRICING_ATTRIBUTE1'
2582: AND QLHB.LIST_HEADER_ID IN (SELECT LIST_HEADER_ID
2583: FROM QP_LIST_HEADERS_B);
2584: IF prclstct = 0 THEN
2585: errLogged := writeError( entity, p_level, p_value, error_type, mesg_name, null,
2586: null, null, null, null, null, null, null, null, null, null );
2587: END IF;