APPS.OZF_FUND_UTILIZED_PVT dependencies on OZF_OFFERS

Line 227: FROM ozf_offers

223:
224: -- yzhao: 11.5.10 get offer's beneficiary account id
225: CURSOR c_offer_info (p_offer_id IN NUMBER) IS
226: SELECT offer_type, volume_offer_type, custom_setup_id
227: FROM ozf_offers
228: WHERE qp_list_header_id = p_offer_id;
229:
230:
231: CURSOR c_sd_request_header_id(p_list_header_id IN NUMBER) IS

Line 356: FROM ozf_offers

352:
353: -- Cursor to get the offer info
354: CURSOR c_offer_qlf_info (p_offer_id IN NUMBER) IS
355: SELECT qualifier_id,qualifier_type
356: FROM ozf_offers
357: WHERE qp_list_header_id = p_offer_id;
358:
359: -- Cursor to get the org_id for cust acct
360: CURSOR c_cust_acct_org_id (p_site_use_id IN NUMBER) IS

Line 3849: SELECT offer_type FROM ozf_offers

3845: l_activity_product_id NUMBER;
3846: l_scan_value NUMBER;
3847:
3848: CURSOR c_offer_type(p_offer_id IN NUMBER) IS
3849: SELECT offer_type FROM ozf_offers
3850: WHERE qp_list_header_id = p_offer_id;
3851:
3852: CURSOR c_off_products (p_offer_id IN NUMBER,p_product_type VARCHAR2,
3853: p_product_id NUMBER,p_channel_id NUMBER) IS