APPS.AMS_CPYUTILITY_PVT dependencies on AMS_ACT_MESSAGES

Line 533: SELECT COUNT(1) from ams_act_messages

529: CURSOR c_csch_exists(p_camp_id NUMBER) IS
530: SELECT COUNT(1) from ams_campaign_schedules_vl
531: WHERE campaign_id = p_camp_id;
532: CURSOR c_mesg_exists(p_obj_id NUMBER, p_obj_type VARCHAR2) IS
533: SELECT COUNT(1) from ams_act_messages
534: WHERE message_used_by_id = p_obj_id
535: AND message_used_by = p_obj_type;
536: CURSOR c_delv_exists(p_obj_id NUMBER, p_obj_type VARCHAR2) IS
537: SELECT COUNT(1)