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 1280: qp_rltd_modifiers qrm where from_rltd_modifier_id

1276: SELECT *
1277: FROM QP_PRICING_ATTRIBUTES qll
1278: WHERE qll.list_line_id IN (select
1279: to_rltd_modifier_id from
1280: qp_rltd_modifiers qrm where from_rltd_modifier_id
1281: = l_list_line_id);
1282:
1283: BEGIN
1284:

Line 1432: FROM qp_rltd_modifiers rm

1428: --Fetch modfier group type (Bug 5465263) Start
1429: BEGIN
1430: SELECT RLTD_MODIFIER_GRP_TYPE
1431: INTO l_rltd_modifier_grp_type
1432: FROM qp_rltd_modifiers rm
1433: WHERE rm.TO_RLTD_MODIFIER_ID = p_PRICING_ATTR_rec.list_line_id;
1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: l_rltd_modifier_grp_type := '';

Line 1636: FROM qp_rltd_modifiers rm

1632: --Fetch modfier group type (Bug 4706180) Start
1633: BEGIN
1634: SELECT RLTD_MODIFIER_GRP_TYPE
1635: INTO l_rltd_modifier_grp_type
1636: FROM qp_rltd_modifiers rm
1637: WHERE rm.TO_RLTD_MODIFIER_ID = p_PRICING_ATTR_rec.list_line_id;
1638: EXCEPTION
1639: WHEN OTHERS THEN
1640: l_rltd_modifier_grp_type := '';

Line 2906: from qp_rltd_modifiers

2902: -- delayed request for changed lines
2903: if QP_PERF_PVT.enabled = 'Y' then
2904: begin
2905: select 'Y' into l_changed_lines
2906: from qp_rltd_modifiers
2907: where to_rltd_modifier_id = p_PRICING_ATTR_rec.list_line_id
2908: and rltd_modifier_grp_type in ('BENEFIT', 'QUALIFIER');
2909: exception
2910: when no_data_found then