DBA Data[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' ;