APPS.QP_PROCESS_OTHER_BENEFITS_PVT dependencies on QP_NUMBER

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

1147: AND instr(d.PROCESS_STATUS, QP_PREQ_PUB.G_FREEGOOD) = 0 -- bug 3006670
1148: AND c.CONTEXT = qp_preq_grp.G_PRIC_VOLUME_CONTEXT
1149: AND c.CONTEXT = a.PRICING_ATTRIBUTE_CONTEXT
1150: AND c.ATTRIBUTE = a.PRICING_ATTRIBUTE
1151: AND qp_number.canonical_to_number(c.VALUE_FROM) BETWEEN
1152: nvl(a.PRICING_ATTR_VALUE_FROM,qp_number.canonical_to_number(c.VALUE_FROM)) AND
1153: nvl(a.PRICING_ATTR_VALUE_TO,qp_number.canonical_to_number(c.VALUE_FROM))
1154: AND c.ATTRIBUTE_TYPE = qp_preq_grp.G_PRICING_TYPE
1155: AND c.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_UNCHANGED

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

1148: AND c.CONTEXT = qp_preq_grp.G_PRIC_VOLUME_CONTEXT
1149: AND c.CONTEXT = a.PRICING_ATTRIBUTE_CONTEXT
1150: AND c.ATTRIBUTE = a.PRICING_ATTRIBUTE
1151: AND qp_number.canonical_to_number(c.VALUE_FROM) BETWEEN
1152: nvl(a.PRICING_ATTR_VALUE_FROM,qp_number.canonical_to_number(c.VALUE_FROM)) AND
1153: nvl(a.PRICING_ATTR_VALUE_TO,qp_number.canonical_to_number(c.VALUE_FROM))
1154: AND c.ATTRIBUTE_TYPE = qp_preq_grp.G_PRICING_TYPE
1155: AND c.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_UNCHANGED
1156: AND e.LINE_INDEX = p_line_index

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

1149: AND c.CONTEXT = a.PRICING_ATTRIBUTE_CONTEXT
1150: AND c.ATTRIBUTE = a.PRICING_ATTRIBUTE
1151: AND qp_number.canonical_to_number(c.VALUE_FROM) BETWEEN
1152: nvl(a.PRICING_ATTR_VALUE_FROM,qp_number.canonical_to_number(c.VALUE_FROM)) AND
1153: nvl(a.PRICING_ATTR_VALUE_TO,qp_number.canonical_to_number(c.VALUE_FROM))
1154: AND c.ATTRIBUTE_TYPE = qp_preq_grp.G_PRICING_TYPE
1155: AND c.PRICING_STATUS_CODE = qp_preq_grp.G_STATUS_UNCHANGED
1156: AND e.LINE_INDEX = p_line_index
1157: AND e.LINE_TYPE_CODE = QP_PREQ_GRP.G_LINE_LEVEL