APPS.QP_PROCESS_OTHER_BENEFITS_PVT dependencies on QP_LIST_LINES

Line 55: FROM QP_LIST_LINES

51: AND b.created_from_list_header_id = p_list_header_id; -- sql repos
52:
53: CURSOR get_list_line_attrs_cur(p_line_id NUMBER) IS
54: SELECT LIST_LINE_TYPE_CODE,OPERAND,BENEFIT_QTY
55: FROM QP_LIST_LINES
56: WHERE LIST_LINE_ID = p_line_id;
57:
58: CURSOR get_modifier_level_code_cur IS
59: SELECT MODIFIER_LEVEL_CODE

Line 60: FROM QP_LIST_LINES

56: WHERE LIST_LINE_ID = p_line_id;
57:
58: CURSOR get_modifier_level_code_cur IS
59: SELECT MODIFIER_LEVEL_CODE
60: FROM QP_LIST_LINES
61: WHERE LIST_LINE_ID = p_list_line_id;
62:
63: v_routine_name CONSTANT VARCHAR2(240):='Routine:QP_Process_Other_Benefits_PVT.Calculate_Recurring_Quantity';
64:

Line 300: FROM QP_LIST_LINES a, QP_RLTD_MODIFIERS b,qp_npreq_ldets_tmp c

296:
297: CURSOR get_related_modifier_id_cur IS
298: SELECT distinct a.PRICE_BREAK_TYPE_CODE , b.FROM_RLTD_MODIFIER_ID,b.TO_RLTD_MODIFIER_ID,c.LINE_DETAIL_INDEX ,
299: a.PRICING_PHASE_ID , a.AUTOMATIC_FLAG,a.LIST_HEADER_ID
300: FROM QP_LIST_LINES a, QP_RLTD_MODIFIERS b,qp_npreq_ldets_tmp c
301: WHERE a.LIST_LINE_ID = b.FROM_RLTD_MODIFIER_ID
302: AND a.LIST_LINE_ID = c.CREATED_FROM_LIST_LINE_ID
303: AND b.RLTD_MODIFIER_GRP_TYPE = qp_preq_grp.G_BENEFIT_TYPE
304: AND c.CREATED_FROM_LIST_LINE_TYPE = qp_preq_grp.G_PROMO_GOODS_DISCOUNT

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 798: FROM QP_LIST_LINES a, QP_RLTD_MODIFIERS b,qp_npreq_ldets_tmp c

794:
795: CURSOR get_related_modifier_id_cur IS
796: SELECT distinct a.LIST_LINE_TYPE_CODE,b.FROM_RLTD_MODIFIER_ID,b.TO_RLTD_MODIFIER_ID , c.LINE_DETAIL_INDEX,
797: a.PRICING_PHASE_ID , a.AUTOMATIC_FLAG
798: FROM QP_LIST_LINES a, QP_RLTD_MODIFIERS b,qp_npreq_ldets_tmp c
799: WHERE a.LIST_LINE_ID = b.FROM_RLTD_MODIFIER_ID
800: AND a.LIST_LINE_ID = c.CREATED_FROM_LIST_LINE_ID
801: AND b.RLTD_MODIFIER_GRP_TYPE = qp_preq_grp.G_BENEFIT_TYPE
802: AND c.CREATED_FROM_LIST_LINE_TYPE = qp_preq_grp.G_OTHER_ITEM_DISCOUNT

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 1091: FROM QP_LIST_LINES a , QP_RLTD_MODIFIERS b

1087: GROUP BY RLTD_MODIFIER_GRP_NO;
1088:
1089: CURSOR rltd_modifiers_cur(p_rltd_grp_no NUMBER) IS
1090: SELECT a.LIST_LINE_TYPE_CODE , b.TO_RLTD_MODIFIER_ID
1091: FROM QP_LIST_LINES a , QP_RLTD_MODIFIERS b
1092: WHERE a.LIST_LINE_ID = b.FROM_RLTD_MODIFIER_ID
1093: AND b.FROM_RLTD_MODIFIER_ID = p_list_line_id
1094: AND b.RLTD_MODIFIER_GRP_TYPE = p_rltd_modifier_type
1095: AND b.RLTD_MODIFIER_GRP_NO = p_rltd_grp_no;