APPS.QP_CALCULATE_PRICE_PUB dependencies on QP_LIST_HEADERS_B

Line 2600: FROM qp_npreq_ldets_tmp a, QP_LIST_HEADERS_B b

2596: GSA_VIOLATION EXCEPTION;
2597:
2598: CURSOR get_source_system_code IS
2599: SELECT b.SOURCE_SYSTEM_CODE
2600: FROM qp_npreq_ldets_tmp a, QP_LIST_HEADERS_B b
2601: WHERE a.CREATED_FROM_LIST_HEADER_ID = b.LIST_HEADER_ID
2602: AND a.LINE_INDEX = p_line_index
2603: AND a.CREATED_FROM_LIST_LINE_TYPE = 'PLL'
2604: AND a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;

Line 2609: qp_npreq_line_attrs_tmp a, QP_PRICING_ATTRIBUTES b, QP_LIST_LINES c, QP_LIST_HEADERS_B d, QP_QUALIFIERS e

2605:
2606: CURSOR get_list_details_cur(p_source_system_code VARCHAR2) IS
2607: SELECT /*+ ORDERED USE_NL(a b c d e) */ c.LIST_LINE_ID, c.OPERAND
2608: FROM
2609: qp_npreq_line_attrs_tmp a, QP_PRICING_ATTRIBUTES b, QP_LIST_LINES c, QP_LIST_HEADERS_B d, QP_QUALIFIERS e
2610: WHERE a.LINE_INDEX = p_line_index
2611: AND a.CONTEXT = b.PRODUCT_ATTRIBUTE_CONTEXT
2612: AND a.ATTRIBUTE = b.PRODUCT_ATTRIBUTE
2613: AND a.VALUE_FROM = b.PRODUCT_ATTR_VALUE