APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_OFFER_DISCOUNT_PRODUCTS

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;

Line 955: FROM ozf_offer_discount_products

951: AND site_use.site_use_id = header.invoice_to_org_id ;
952:
953: CURSOR c_apply_discount(p_offer_id IN NUMBER,p_product_id IN VARCHAR2) IS
954: SELECT NVL(apply_discount_flag,'N')
955: FROM ozf_offer_discount_products
956: WHERE offer_id = p_offer_id
957: AND product_attr_value = p_product_id;
958:
959: CURSOR c_get_items_type(p_list_header_id number,p_inventory_item_id IN NUMBER) IS