APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_OFFER_DISCOUNT_PRODUCTS

Line 1048: FROM ozf_offer_discount_products op, ozf_qp_discounts oq

1044:
1045: --query to retrieve list_line_id
1046: CURSOR c_list_line (p_offer_id IN NUMBER, p_product_id IN VARCHAR2) IS
1047: SELECT oq.list_line_id, op.product_attribute, op.product_attr_value
1048: FROM ozf_offer_discount_products op, ozf_qp_discounts oq
1049: WHERE (op.product_attr_value = p_product_id OR op.product_attr_value = 'ALL')
1050: AND op.offer_id = p_offer_id
1051: AND op.offer_discount_line_id = oq.offer_discount_line_id
1052: AND rownum = 1;

Line 1115: FROM ozf_offer_discount_products

1111: AND site_use.site_use_id = header.invoice_to_org_id ;
1112:
1113: CURSOR c_apply_discount(p_offer_id IN NUMBER,p_product_id IN VARCHAR2) IS
1114: SELECT NVL(apply_discount_flag,'N')
1115: FROM ozf_offer_discount_products
1116: WHERE offer_id = p_offer_id
1117: AND product_attr_value = p_product_id;
1118:
1119: CURSOR c_get_items_type(p_list_header_id number,p_inventory_item_id IN NUMBER) IS