APPS.AMS_TRIG_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 574: FROM ams_campaign_schedules_b

570: WHERE trigger_id = p_trigger_id ;
571:
572: /*CURSOR c_assoc_sch IS
573: SELECT count(*)
574: FROM ams_campaign_schedules_b
575: WHERE trigger_id = p_trigger_id;
576: */
577: l_trig_rec c_trig_det%ROWTYPE ;
578: l_mode VARCHAR2(30);

Line 647: FROM ams_campaign_schedules_b

643: -----------------------------------------------------------------------
644:
645: SELECT count(*)
646: INTO l_assoc_sch -- number of schedules associated with this triggerId
647: FROM ams_campaign_schedules_b
648: WHERE trigger_id = p_trigger_id;
649:
650: -------------------------------------------------------
651: -- Following code is modified by soagrawa on 13-may-2003