APPS.QP_PROCESS_OTHER_BENEFITS_PVT dependencies on QP_PRICING_ATTRIBUTES

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

312: b.PRICING_GROUP_SEQUENCE, b.ARITHMETIC_OPERATOR,b.OPERAND,b.PRICING_PHASE_ID,
313: b.BENEFIT_PRICE_LIST_LINE_ID, b.BENEFIT_UOM_CODE,b.BENEFIT_QTY,b.LIST_PRICE,
314: b.PRICE_BREAK_TYPE_CODE,b.AUTOMATIC_FLAG, c.PRODUCT_ATTRIBUTE_CONTEXT, c.PRODUCT_ATTRIBUTE,
315: c.PRODUCT_ATTR_VALUE,c.PRODUCT_UOM_CODE , b.ACCRUAL_FLAG,b.MODIFIER_LEVEL_CODE
316: FROM QP_LIST_HEADERS_B a ,QP_LIST_LINES b,QP_PRICING_ATTRIBUTES c
317: WHERE a.LIST_HEADER_ID = b.LIST_HEADER_ID
318: AND b.LIST_LINE_ID = c.LIST_LINE_ID
319: AND b.LIST_LINE_ID= p_related_modifier_id;
320:

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

809: SELECT distinct a.LIST_TYPE_CODE,b.LIST_HEADER_ID,b.LIST_LINE_ID,b.LIST_LINE_TYPE_CODE,
810: b.PRICING_GROUP_SEQUENCE, b.ARITHMETIC_OPERATOR,b.OPERAND,b.AUTOMATIC_FLAG,
811: b.BENEFIT_PRICE_LIST_LINE_ID,b.LIST_PRICE, c.PRODUCT_ATTRIBUTE_CONTEXT,
812: c.PRODUCT_ATTRIBUTE,c.PRODUCT_ATTR_VALUE , b.ACCRUAL_FLAG,b.MODIFIER_LEVEL_CODE
813: FROM QP_LIST_HEADERS_B a ,QP_LIST_LINES b, QP_PRICING_ATTRIBUTES c
814: WHERE a.LIST_HEADER_ID = b.LIST_HEADER_ID
815: AND b.LIST_LINE_ID = c.LIST_LINE_ID
816: AND b.LIST_LINE_ID= p_related_modifier_id;
817:

Line 1102: FROM QP_PRICING_ATTRIBUTES c

1098: -- line category
1099: CURSOR check_rltd_mods_passed_cur(p_rltd_modifier_id NUMBER) IS
1100: -- 10g/R12 performance fixes for 5573393
1101: SELECT distinct c.LIST_LINE_ID
1102: FROM QP_PRICING_ATTRIBUTES c
1103: WHERE c.LIST_LINE_ID = p_rltd_modifier_id
1104: AND c.PRICING_ATTRIBUTE_CONTEXT IS NULL
1105: AND EXISTS
1106: (SELECT /*+ ORDERED NO_UNNEST index(b qp_preq_line_attrs_tmp_n2)

Line 1127: FROM QP_PRICING_ATTRIBUTES a

1123: AND nvl(d.LINE_CATEGORY,'ORDER') = nvl(a.LINE_CATEGORY,'ORDER'))
1124: UNION
1125: -- 10g/R12 performance fixes for 5573393
1126: SELECT distinct a.LIST_LINE_ID -- Index N7 can be replaced with N2
1127: FROM QP_PRICING_ATTRIBUTES a
1128: WHERE a.LIST_LINE_ID = p_rltd_modifier_id
1129: AND EXISTS
1130: (SELECT /*+ ORDERED NO_UNNEST index(b qp_preq_line_attrs_n2)
1131: index(d qp_preq_lines_tmp_u1)