APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_QP_DISCOUNTS

Line 889: FROM ozf_offer_discount_products op, ozf_qp_discounts oq

885:
886: --query to retrieve list_line_id
887: CURSOR c_list_line (p_offer_id IN NUMBER, p_product_id IN VARCHAR2) IS
888: SELECT oq.list_line_id, op.product_attribute, op.product_attr_value
889: FROM ozf_offer_discount_products op, ozf_qp_discounts oq
890: WHERE (op.product_attr_value = p_product_id OR op.product_attr_value = 'ALL')
891: AND op.offer_id = p_offer_id
892: AND op.offer_discount_line_id = oq.offer_discount_line_id
893: AND rownum = 1;