APPS.QP_PRICING_ENGINE_PVT dependencies on QP_RLTD_MODIFIERS

Line 118: FROM QP_PRICING_ATTRIBUTES qpbl , QP_RLTD_MODIFIERS qprl, QP_LIST_LINES qpl

114: p_qualifier_context VARCHAR2 , p_qualifier_attribute VARCHAR2 ) IS
115:
116: SELECT qpbl.PRICING_ATTRIBUTE_ID,qpbl.LIST_LINE_ID,qpbl.PRICING_ATTRIBUTE_CONTEXT,qpbl.PRICING_ATTRIBUTE,
117: qpbl.PRICING_ATTR_VALUE_FROM, qpbl.PRICING_ATTR_VALUE_TO,qpl.OPERAND , qpl.ARITHMETIC_OPERATOR
118: FROM QP_PRICING_ATTRIBUTES qpbl , QP_RLTD_MODIFIERS qprl, QP_LIST_LINES qpl
119: WHERE qpl.LIST_LINE_ID = qpbl.LIST_LINE_ID
120: AND qpbl.LIST_LINE_ID = qprl.TO_RLTD_MODIFIER_ID
121: AND qpbl.PRODUCT_ATTRIBUTE_CONTEXT = p_product_attribute_context
122: AND qpbl.PRODUCT_ATTRIBUTE = p_product_attribute

Line 131: FROM QP_PRICING_ATTRIBUTES qpbl , QP_LIST_LINES qpl, QP_QUALIFIERS qpq, QP_RLTD_MODIFIERS qprl

127: AND nvl(qpl.END_DATE_ACTIVE,trunc(p_pricing_date))
128: UNION
129: SELECT qpbl.PRICING_ATTRIBUTE_ID,qpbl.LIST_LINE_ID,qpbl.PRICING_ATTRIBUTE_CONTEXT,qpbl.PRICING_ATTRIBUTE,
130: qpbl.PRICING_ATTR_VALUE_FROM, qpbl.PRICING_ATTR_VALUE_TO,qpl.OPERAND , qpl.ARITHMETIC_OPERATOR
131: FROM QP_PRICING_ATTRIBUTES qpbl , QP_LIST_LINES qpl, QP_QUALIFIERS qpq, QP_RLTD_MODIFIERS qprl
132: WHERE qpq.LIST_LINE_ID = p_list_line_id
133: AND qpq.QUALIFIER_CONTEXT = p_qualifier_context
134: AND qpq.QUALIFIER_ATTRIBUTE = p_qualifier_attribute
135: AND qpq.QUALIFIER_ATTR_VALUE = p_attribute_value

Line 139: FROM QP_RLTD_MODIFIERS qprl

135: AND qpq.QUALIFIER_ATTR_VALUE = p_attribute_value
136: AND qpbl.LIST_LINE_ID = qprl.TO_RLTD_MODIFIER_ID
137: AND qpl.LIST_LINE_ID = qpbl.LIST_LINE_ID
138: AND qpl.LIST_LINE_ID IN ( SELECT TO_RLTD_MODIFIER_ID
139: FROM QP_RLTD_MODIFIERS qprl
140: WHERE qprl.FROM_RLTD_MODIFIER_ID = p_list_line_id)
141: AND trunc(p_pricing_date) BETWEEN nvl(qpl.START_DATE_ACTIVE,trunc(p_pricing_date))
142: AND nvl(qpl.END_DATE_ACTIVE,trunc(p_pricing_date));
143: BEGIN

Line 164: FROM QP_RLTD_MODIFIERS

160:
161: BEGIN
162: SELECT 'x'
163: INTO v_dummy
164: FROM QP_RLTD_MODIFIERS
165: WHERE TO_RLTD_MODIFIER_ID = i.list_line_id;
166: EXCEPTION
167: WHEN NO_DATA_FOUND THEN
168: v_dummy := NULL;