APPS.QP_CALCULATE_PRICE_PUB dependencies on QP_LIST_HEADERS_B

Line 2656: FROM qp_npreq_ldets_tmp a, QP_LIST_HEADERS_B b

2652: GSA_VIOLATION EXCEPTION;
2653:
2654: CURSOR get_source_system_code IS
2655: SELECT b.SOURCE_SYSTEM_CODE
2656: FROM qp_npreq_ldets_tmp a, QP_LIST_HEADERS_B b
2657: WHERE a.CREATED_FROM_LIST_HEADER_ID = b.LIST_HEADER_ID
2658: AND a.LINE_INDEX = p_line_index
2659: AND a.CREATED_FROM_LIST_LINE_TYPE = 'PLL'
2660: AND a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;

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

2661:
2662: CURSOR get_list_details_cur(p_source_system_code VARCHAR2) IS
2663: SELECT /*+ ORDERED USE_NL(a b c d e) */ c.LIST_LINE_ID, c.OPERAND
2664: FROM
2665: qp_npreq_line_attrs_tmp a, QP_PRICING_ATTRIBUTES b, QP_LIST_LINES c, QP_LIST_HEADERS_B d, QP_QUALIFIERS e
2666: WHERE a.LINE_INDEX = p_line_index
2667: AND a.CONTEXT = b.PRODUCT_ATTRIBUTE_CONTEXT
2668: AND a.ATTRIBUTE = b.PRODUCT_ATTRIBUTE
2669: AND a.VALUE_FROM = b.PRODUCT_ATTR_VALUE