APPS.QP_PROCESS_OTHER_BENEFITS_PVT dependencies on QP_NUMBER

Line 1191: AND qp_number.canonical_to_number(c.VALUE_FROM) BETWEEN

1187: AND instr(d.PROCESS_STATUS, QP_PREQ_PUB.G_FREEGOOD) = 0 -- bug 3006670
1188: AND c.CONTEXT = qp_preq_grp.G_PRIC_VOLUME_CONTEXT
1189: AND c.CONTEXT = a.PRICING_ATTRIBUTE_CONTEXT
1190: AND c.ATTRIBUTE = a.PRICING_ATTRIBUTE
1191: AND qp_number.canonical_to_number(c.VALUE_FROM) BETWEEN
1192: nvl(a.PRICING_ATTR_VALUE_FROM,qp_number.canonical_to_number(c.VALUE_FROM)) AND
1193: nvl(a.PRICING_ATTR_VALUE_TO,qp_number.canonical_to_number(c.VALUE_FROM))
1194: AND c.ATTRIBUTE_TYPE = qp_preq_grp.G_PRICING_TYPE
1195: AND c.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_UNCHANGED

Line 1192: nvl(a.PRICING_ATTR_VALUE_FROM,qp_number.canonical_to_number(c.VALUE_FROM)) AND

1188: AND c.CONTEXT = qp_preq_grp.G_PRIC_VOLUME_CONTEXT
1189: AND c.CONTEXT = a.PRICING_ATTRIBUTE_CONTEXT
1190: AND c.ATTRIBUTE = a.PRICING_ATTRIBUTE
1191: AND qp_number.canonical_to_number(c.VALUE_FROM) BETWEEN
1192: nvl(a.PRICING_ATTR_VALUE_FROM,qp_number.canonical_to_number(c.VALUE_FROM)) AND
1193: nvl(a.PRICING_ATTR_VALUE_TO,qp_number.canonical_to_number(c.VALUE_FROM))
1194: AND c.ATTRIBUTE_TYPE = qp_preq_grp.G_PRICING_TYPE
1195: AND c.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_UNCHANGED
1196: AND e.LINE_INDEX = p_line_index

Line 1193: nvl(a.PRICING_ATTR_VALUE_TO,qp_number.canonical_to_number(c.VALUE_FROM))

1189: AND c.CONTEXT = a.PRICING_ATTRIBUTE_CONTEXT
1190: AND c.ATTRIBUTE = a.PRICING_ATTRIBUTE
1191: AND qp_number.canonical_to_number(c.VALUE_FROM) BETWEEN
1192: nvl(a.PRICING_ATTR_VALUE_FROM,qp_number.canonical_to_number(c.VALUE_FROM)) AND
1193: nvl(a.PRICING_ATTR_VALUE_TO,qp_number.canonical_to_number(c.VALUE_FROM))
1194: AND c.ATTRIBUTE_TYPE = qp_preq_grp.G_PRICING_TYPE
1195: AND c.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_UNCHANGED
1196: AND e.LINE_INDEX = p_line_index
1197: AND e.LINE_TYPE_CODE = QP_PREQ_GRP.G_LINE_LEVEL