APPS.OZF_FUND_UTILIZED_PUB dependencies on AMS_MEDIA_CHANNELS_VL

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: