[Home] [Help]
APPS.AMS_ACTIVATE_EVENTSCHED_PVT dependencies on AMS_USER_STATUSES_B
Line 78: FROM ams_user_statuses_b
74: --End Adding
75:
76: CURSOR c_status(l_status_code VARCHAR2) IS
77: SELECT user_status_id
78: FROM ams_user_statuses_b
79: WHERE system_status_type = 'AMS_EVENT_STATUS'
80: AND system_status_code = l_status_code
81: AND default_flag = 'Y'
82: AND enabled_flag = 'Y' ;