APPS.OZF_FUND_UTILIZED_PVT dependencies on OZF_OFFERS

Line 332: FROM ozf_offers

328:
329: -- yzhao: 11.5.10 get offer's beneficiary account id
330: CURSOR c_offer_info (p_offer_id IN NUMBER) IS
331: SELECT offer_type, volume_offer_type, custom_setup_id
332: FROM ozf_offers
333: WHERE qp_list_header_id = p_offer_id;
334:
335:
336: CURSOR c_sd_request_header_id(p_list_header_id IN NUMBER) IS

Line 4344: SELECT offer_type FROM ozf_offers

4340: l_scan_value NUMBER;
4341: l_utilized_amount NUMBER;
4342:
4343: CURSOR c_offer_type(p_offer_id IN NUMBER) IS
4344: SELECT offer_type FROM ozf_offers
4345: WHERE qp_list_header_id = p_offer_id;
4346:
4347: CURSOR c_off_products (p_offer_id IN NUMBER,p_product_type VARCHAR2,
4348: p_product_id NUMBER,p_channel_id NUMBER) IS

Line 4371: FROM ozf_offers

4367:
4368: CURSOR c_offer_currency (p_activity_id IN NUMBER) IS
4369: SELECT NVL(transaction_currency_code,fund_request_curr_code) fund_request_curr_code,
4370: transaction_currency_code
4371: FROM ozf_offers
4372: WHERE qp_list_header_id = p_activity_id;
4373: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
4374: l_rate NUMBER;
4375: l_offer_currency c_offer_currency%ROWTYPE;