DBA Data[Home] [Help]

APPS.OZF_VOLUME_CALCULATION_PUB dependencies on OZF_OFFER_DISCOUNT_PRODUCTS

Line 1541: FROM ozf_offer_discount_products

1537: WHERE resale_line_int_id = p_order_line_id;
1538:
1539: CURSOR c_discount_volume(p_offer_id NUMBER, p_prod_attribute VARCHAR2, p_prod_attr_value VARCHAR2) IS
1540: SELECT apply_discount_flag, include_volume_flag
1541: FROM ozf_offer_discount_products
1542: WHERE product_context = 'ITEM'
1543: AND product_attribute = p_prod_attribute
1544: AND product_attr_value = p_prod_attr_value
1545: AND offer_id = p_offer_id;