APPS.OZF_FUND_UTILIZED_PUB dependencies on OZF_OFFERS

Line 144: FROM ams_media_channels_vl med, ozf_offers off

140: AND hzs.site_use_id = p_cust_id;
141:
142: CURSOR c_valid_scantype_id (p_activity_id IN NUMBER, p_scan_type_id IN NUMBER) IS
143: SELECT 1
144: FROM ams_media_channels_vl med, ozf_offers off
145: WHERE med.media_id = off.activity_media_id(+)
146: AND qp_list_header_id = p_activity_id
147: AND channel_id = p_scan_type_id;
148:

Line 237: FROM ozf_offers

233: AND l.line_id = p_order_line_id ;
234:
235: CURSOR c_offer_info (p_activity_id IN NUMBER) IS
236: SELECT beneficiary_account_id,autopay_party_attr,autopay_party_id
237: FROM ozf_offers
238: WHERE qp_list_header_id = p_activity_id;
239:
240: -- Cursor to get the org_id for third party order
241: CURSOR c_tp_order_org_id (p_line_id IN NUMBER) IS

Line 265: FROM ozf_offers

261: --nirprasa,ER 8399134
262: CURSOR c_get_offer_currency (p_activity_id IN NUMBER) IS
263: SELECT NVL(transaction_currency_code,fund_request_curr_code) fund_request_curr_code,
264: transaction_currency_code
265: FROM ozf_offers
266: WHERE qp_list_header_id=p_activity_id;
267:
268: CURSOR c_get_order_currency (p_document_number IN NUMBER) IS
269: SELECT transactional_curr_code