APPS.QP_PROCESS_OTHER_BENEFITS_PVT dependencies on QP_RLTD_MODIFIERS

Line 292: -- Get the Related Modifier id from qp_rltd_modifiers table

288: p_pricing_phase_id NUMBER,
289: x_return_status OUT NOCOPY VARCHAR2,
290: x_return_status_txt OUT NOCOPY VARCHAR2) AS
291:
292: -- Get the Related Modifier id from qp_rltd_modifiers table
293: -- Insert a line into the qp_npreq_lines_tmp table for the other item
294: -- Insert a line into qp_npreq_rltd_lines_tmp
295: -- Insert a line into qp_npreq_ldets_tmp table for discount on the new line
296:

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 826: -- Get the Related Modifier id from qp_rltd_modifiers table

822: p_pricing_phase_id NUMBER,
823: x_return_status OUT NOCOPY VARCHAR2,
824: x_return_status_txt OUT NOCOPY VARCHAR2) AS
825:
826: -- Get the Related Modifier id from qp_rltd_modifiers table
827: -- Insert a line into the qp_npreq_lines_tmp table for the other item
828: -- Insert a line into qp_npreq_rltd_lines_tmp
829: -- Insert a line into qp_npreq_ldets_tmp table for discount on the new line
830:

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 1124: FROM QP_RLTD_MODIFIERS

1120: x_return_status_txt OUT NOCOPY VARCHAR2) AS
1121:
1122: CURSOR no_rltd_modifiers_in_grp_cur IS
1123: SELECT RLTD_MODIFIER_GRP_NO,COUNT(*) NO_OF_MODIFIERS_IN_GRP
1124: FROM QP_RLTD_MODIFIERS
1125: WHERE FROM_RLTD_MODIFIER_ID = p_list_line_id
1126: AND RLTD_MODIFIER_GRP_TYPE = p_rltd_modifier_type
1127: GROUP BY RLTD_MODIFIER_GRP_NO;
1128:

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;