APPS.QP_PROCESS_OTHER_BENEFITS_PVT dependencies on QP_LIST_LINES

Line 53: FROM QP_LIST_LINES

49: AND a.LIST_HEADER_ID = p_list_header_id;
50:
51: CURSOR get_list_line_attrs_cur(p_line_id NUMBER) IS
52: SELECT LIST_LINE_TYPE_CODE,OPERAND,BENEFIT_QTY
53: FROM QP_LIST_LINES
54: WHERE LIST_LINE_ID = p_line_id;
55:
56: CURSOR get_modifier_level_code_cur IS
57: SELECT MODIFIER_LEVEL_CODE

Line 58: FROM QP_LIST_LINES

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

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

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

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

333:
334:
335: CURSOR get_list_price_cur(p_line_id NUMBER) IS
336: SELECT a.LIST_HEADER_ID,a.LIST_LINE_ID,a.OPERAND,b.ROUNDING_FACTOR, a.ARITHMETIC_OPERATOR -- service project
337: FROM QP_LIST_LINES a ,QP_LIST_HEADERS_B b
338: WHERE a.LIST_LINE_ID = p_line_id
339: AND a.LIST_HEADER_ID = b.LIST_HEADER_ID;
340:
341: CURSOR get_request_type_code_cur IS

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

834:
835: CURSOR get_related_modifier_id_cur IS
836: SELECT distinct a.LIST_LINE_TYPE_CODE,b.FROM_RLTD_MODIFIER_ID,b.TO_RLTD_MODIFIER_ID , c.LINE_DETAIL_INDEX,
837: a.PRICING_PHASE_ID , a.AUTOMATIC_FLAG
838: FROM QP_LIST_LINES a, QP_RLTD_MODIFIERS b,qp_npreq_ldets_tmp c
839: WHERE a.LIST_LINE_ID = b.FROM_RLTD_MODIFIER_ID
840: AND a.LIST_LINE_ID = c.CREATED_FROM_LIST_LINE_ID
841: AND b.RLTD_MODIFIER_GRP_TYPE = qp_preq_grp.G_BENEFIT_TYPE
842: AND c.CREATED_FROM_LIST_LINE_TYPE = qp_preq_grp.G_OTHER_ITEM_DISCOUNT

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

1127: GROUP BY RLTD_MODIFIER_GRP_NO;
1128:
1129: CURSOR rltd_modifiers_cur(p_rltd_grp_no NUMBER) IS
1130: SELECT a.LIST_LINE_TYPE_CODE , b.TO_RLTD_MODIFIER_ID
1131: FROM QP_LIST_LINES a , QP_RLTD_MODIFIERS b
1132: WHERE a.LIST_LINE_ID = b.FROM_RLTD_MODIFIER_ID
1133: AND b.FROM_RLTD_MODIFIER_ID = p_list_line_id
1134: AND b.RLTD_MODIFIER_GRP_TYPE = p_rltd_modifier_type
1135: AND b.RLTD_MODIFIER_GRP_NO = p_rltd_grp_no;