APPS.AMS_LIST_ASSOC_PVT dependencies on AMS_MEDIA_VL

Line 732: from ams_media_vl

728: IS
729: l_media_id NUMBER;
730: CURSOR c_media_id IS
731: select media_id
732: from ams_media_vl
733: where media_type_code='DIRECT_MARKETING'
734: and media_id=p_list_assoc_rec.media_id;
735:
736: l_camp_id NUMBER;