APPS.QP_PRICING_ATTR_UTIL dependencies on QP_RLTD_MODIFIERS

Line 729: FROM qp_rltd_modifiers rm

725: --Fetch modfier group type (Bug 4706180) Start
726: BEGIN
727: SELECT RLTD_MODIFIER_GRP_TYPE
728: INTO l_rltd_modifier_grp_type
729: FROM qp_rltd_modifiers rm
730: WHERE rm.TO_RLTD_MODIFIER_ID = p_PRICING_ATTR_rec.list_line_id;
731: EXCEPTION
732: WHEN OTHERS THEN
733: l_rltd_modifier_grp_type := '';

Line 796: from qp_list_lines ql, qp_rltd_modifiers qrm

792: SET product_uom_code = p_PRICING_ATTR_rec.product_uom_code
793: where list_line_id in
794: (
795: select to_rltd_modifier_id
796: from qp_list_lines ql, qp_rltd_modifiers qrm
797: where from_rltd_modifier_id= p_PRICING_ATTR_rec.list_line_id
798: AND qrm.to_rltd_modifier_id = ql.list_line_id
799: AND qrm.rltd_modifier_grp_type = 'PRICE BREAK'
800: ) ;

Line 1264: qp_rltd_modifiers qrm where from_rltd_modifier_id

1260: SELECT *
1261: FROM QP_PRICING_ATTRIBUTES qll
1262: WHERE qll.list_line_id IN (select
1263: to_rltd_modifier_id from
1264: qp_rltd_modifiers qrm where from_rltd_modifier_id
1265: = l_list_line_id);
1266:
1267: BEGIN
1268:

Line 1416: FROM qp_rltd_modifiers rm

1412: --Fetch modfier group type (Bug 5465263) Start
1413: BEGIN
1414: SELECT RLTD_MODIFIER_GRP_TYPE
1415: INTO l_rltd_modifier_grp_type
1416: FROM qp_rltd_modifiers rm
1417: WHERE rm.TO_RLTD_MODIFIER_ID = p_PRICING_ATTR_rec.list_line_id;
1418: EXCEPTION
1419: WHEN OTHERS THEN
1420: l_rltd_modifier_grp_type := '';

Line 1620: FROM qp_rltd_modifiers rm

1616: --Fetch modfier group type (Bug 4706180) Start
1617: BEGIN
1618: SELECT RLTD_MODIFIER_GRP_TYPE
1619: INTO l_rltd_modifier_grp_type
1620: FROM qp_rltd_modifiers rm
1621: WHERE rm.TO_RLTD_MODIFIER_ID = p_PRICING_ATTR_rec.list_line_id;
1622: EXCEPTION
1623: WHEN OTHERS THEN
1624: l_rltd_modifier_grp_type := '';

Line 2816: from qp_rltd_modifiers

2812: -- delayed request for changed lines
2813: if QP_PERF_PVT.enabled = 'Y' then
2814: begin
2815: select 'Y' into l_changed_lines
2816: from qp_rltd_modifiers
2817: where to_rltd_modifier_id = p_PRICING_ATTR_rec.list_line_id
2818: and rltd_modifier_grp_type in ('BENEFIT', 'QUALIFIER');
2819: exception
2820: when no_data_found then