APPS.OZF_FUND_UTILIZED_PUB dependencies on AMS_MEDIA_CHANNELS_VL

Line 120: FROM ams_media_channels_vl med, ozf_offers off

116: AND hzs.site_use_id = p_cust_id;
117:
118: CURSOR c_valid_scantype_id (p_activity_id IN NUMBER, p_scan_type_id IN NUMBER) IS
119: SELECT 1
120: FROM ams_media_channels_vl med, ozf_offers off
121: WHERE med.media_id = off.activity_media_id(+)
122: AND qp_list_header_id = p_activity_id
123: AND channel_id = p_scan_type_id;
124: