DBA Data[Home] [Help]

APPS.AMS_SCHEDULER_PVT dependencies on AMS_MEDIA_CHANNELS

Line 209: FROM ams_media_channels

205: l_parent_rec c_sched%ROWTYPE;
206:
207: CURSOR c_channel_media(p_medium_id NUMBER, p_activity_id NUMBER) IS
208: SELECT 1
209: FROM ams_media_channels
210: WHERE channel_id = p_medium_id
211: AND media_id = p_activity_id
212: AND ACTIVE_TO_DATE > SYSDATE;
213: