APPS.AMS_TRIGGER_PVT_OA dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 495: SELECT count(1) from ams_campaign_schedules_b

491: IS
492: l_delete VARCHAR2(1):='Y';
493:
494: CURSOR c_get_csch_count(p_trigId IN NUMBER) IS
495: SELECT count(1) from ams_campaign_schedules_b
496: WHERE trigger_id = p_trigId
497: and triggerable_flag = 'Y';
498: l_csch_count NUMBER := 0;
499: BEGIN