APPS.AMS_LIST_ASSOC_PVT dependencies on AMS_CAMPAIGNS_VL

Line 738: select campaign_id from ams_campaigns_vl where rollup_type<>'RCAM'

734: and media_id=p_list_assoc_rec.media_id;
735:
736: l_camp_id NUMBER;
737: CURSOR c_camp_id IS
738: select campaign_id from ams_campaigns_vl where rollup_type<>'RCAM'
739: and active_flag='Y'
740: and show_campaign_flag='Y'
741: and status_code not in ('ARCHIVED','CANCELLED')
742: and campaign_id=p_list_assoc_rec.list_used_by_id ;