DBA Data[Home] [Help]

APPS.AMS_CPYUTILITY_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_VL

Line 530: SELECT COUNT(1) from ams_campaign_schedules_vl

526: p_obj_attribute IN VARCHAR2
527: ) RETURN VARCHAR2
528: IS
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