APPS.AMS_SCHEDULER_PVT dependencies on AMS_USER_STATUSES_B

Line 216: FROM ams_user_statuses_b

212: AND ACTIVE_TO_DATE > SYSDATE;
213:
214: CURSOR c_def_status(p_status_code VARCHAR2) IS
215: SELECT user_status_id
216: FROM ams_user_statuses_b
217: WHERE system_status_type = 'AMS_CAMPAIGN_SCHEDULE_STATUS'
218: AND system_status_code = p_status_code
219: AND default_flag = 'Y'
220: AND enabled_flag = 'Y';