DBA Data[Home] [Help]

APPS.OM_SETUP_VALID_PKG dependencies on QP_LIST_LINES_V

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'))