DBA Data[Home] [Help]

APPS.OZF_VOLUME_CALCULATION_PUB dependencies on OZF_OFFER_DISCOUNT_PRODUCTS

Line 1971: FROM ozf_offer_discount_products

1967: WHERE resale_line_int_id = p_order_line_id;
1968:
1969: CURSOR c_discount_volume(p_offer_id NUMBER, p_prod_attribute VARCHAR2, p_prod_attr_value VARCHAR2) IS
1970: SELECT apply_discount_flag, include_volume_flag
1971: FROM ozf_offer_discount_products
1972: WHERE product_context = 'ITEM'
1973: AND product_attribute = p_prod_attribute
1974: AND product_attr_value = p_prod_attr_value
1975: AND offer_id = p_offer_id;