APPS.AMS_CAMPAIGNRULES_PVT dependencies on AMS_MEDIA_VL

Line 871: FROM ams_media_vl

867: l_dummy NUMBER;
868:
869: CURSOR c_media IS
870: SELECT media_type_code
871: FROM ams_media_vl
872: WHERE media_id = p_media_id
873: AND enabled_flag = 'Y';
874:
875: CURSOR c_channel_media IS