APPS.QP_PROCESS_OTHER_BENEFITS_PVT dependencies on QP_LIST_HEADERS_B

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 331: FROM QP_LIST_LINES a ,QP_LIST_HEADERS_B b

327:
328:
329: CURSOR get_list_price_cur(p_line_id NUMBER) IS
330: SELECT a.LIST_HEADER_ID,a.LIST_LINE_ID,a.OPERAND,b.ROUNDING_FACTOR
331: FROM QP_LIST_LINES a ,QP_LIST_HEADERS_B b
332: WHERE a.LIST_LINE_ID = p_line_id
333: AND a.LIST_HEADER_ID = b.LIST_HEADER_ID
334: AND a.ARITHMETIC_OPERATOR = qp_preq_grp.G_UNIT_PRICE;
335:

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: