APPS.QP_COUPON_PVT dependencies on QP_PREQ_PUB

Line 1067: and qpd.APPLIED_FLAG = QP_PREQ_PUB.G_YES

1063: and qpq.qualifier_attribute = qplat.attribute
1064: and qpq.QUALIFIER_ATTR_VALUE = qplat.value_from
1065: and qpc.coupon_id = to_number(qplat.value_from)
1066: and qpq.list_line_id = qpd.CREATED_FROM_LIST_LINE_ID
1067: and qpd.APPLIED_FLAG = QP_PREQ_PUB.G_YES
1068: and qpd.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;
1069:
1070: l_return_status VARCHAR2(1);
1071: l_satis_quals_opt VARCHAR2(1);