APPS.QP_PROCESS_OTHER_BENEFITS_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 322: FROM QP_LIST_HEADERS_B a ,QP_LIST_LINES b,QP_PRICING_ATTRIBUTES c

318: b.SERVICE_DURATION,b.SERVICE_PERIOD,-- SERVICE PROJECT
319: b.BENEFIT_QTY,b.LIST_PRICE,
320: b.PRICE_BREAK_TYPE_CODE,b.AUTOMATIC_FLAG, c.PRODUCT_ATTRIBUTE_CONTEXT, c.PRODUCT_ATTRIBUTE,
321: c.PRODUCT_ATTR_VALUE,c.PRODUCT_UOM_CODE , b.ACCRUAL_FLAG,b.MODIFIER_LEVEL_CODE
322: FROM QP_LIST_HEADERS_B a ,QP_LIST_LINES b,QP_PRICING_ATTRIBUTES c
323: WHERE a.LIST_HEADER_ID = b.LIST_HEADER_ID
324: AND b.LIST_LINE_ID = c.LIST_LINE_ID
325: AND b.LIST_LINE_ID= p_related_modifier_id;
326:

Line 853: FROM QP_LIST_HEADERS_B a ,QP_LIST_LINES b, QP_PRICING_ATTRIBUTES c

849: SELECT distinct a.LIST_TYPE_CODE,b.LIST_HEADER_ID,b.LIST_LINE_ID,b.LIST_LINE_TYPE_CODE,
850: b.PRICING_GROUP_SEQUENCE, b.ARITHMETIC_OPERATOR,b.OPERAND,b.AUTOMATIC_FLAG,
851: b.BENEFIT_PRICE_LIST_LINE_ID,b.LIST_PRICE, c.PRODUCT_ATTRIBUTE_CONTEXT,
852: c.PRODUCT_ATTRIBUTE,c.PRODUCT_ATTR_VALUE , b.ACCRUAL_FLAG,b.MODIFIER_LEVEL_CODE
853: FROM QP_LIST_HEADERS_B a ,QP_LIST_LINES b, QP_PRICING_ATTRIBUTES c
854: WHERE a.LIST_HEADER_ID = b.LIST_HEADER_ID
855: AND b.LIST_LINE_ID = c.LIST_LINE_ID
856: AND b.LIST_LINE_ID= p_related_modifier_id;
857:

Line 1142: FROM QP_PRICING_ATTRIBUTES c

1138: -- line category
1139: CURSOR check_rltd_mods_passed_cur(p_rltd_modifier_id NUMBER) IS
1140: -- 10g/R12 performance fixes for 5573393
1141: SELECT distinct c.LIST_LINE_ID
1142: FROM QP_PRICING_ATTRIBUTES c
1143: WHERE c.LIST_LINE_ID = p_rltd_modifier_id
1144: AND c.PRICING_ATTRIBUTE_CONTEXT IS NULL
1145: AND EXISTS
1146: (SELECT /*+ ORDERED NO_UNNEST index(b qp_preq_line_attrs_tmp_n2)

Line 1167: FROM QP_PRICING_ATTRIBUTES a

1163: AND nvl(d.LINE_CATEGORY,'ORDER') = nvl(a.LINE_CATEGORY,'ORDER'))
1164: UNION
1165: -- 10g/R12 performance fixes for 5573393
1166: SELECT distinct a.LIST_LINE_ID -- Index N7 can be replaced with N2
1167: FROM QP_PRICING_ATTRIBUTES a
1168: WHERE a.LIST_LINE_ID = p_rltd_modifier_id
1169: AND EXISTS
1170: (SELECT /*+ ORDERED NO_UNNEST index(b qp_preq_line_attrs_n2)
1171: index(d qp_preq_lines_tmp_u1)