APPS.AMS_REGISTRANTS_PUB dependencies on AMS_USER_STATUSES_VL

Line 170: from ams_user_statuses_vl

166: where confirmation_code = p_confirmation_code;
167:
168: Cursor c_find_status_id(l_system_status_code VARCHAR2) is
169: select user_status_id
170: from ams_user_statuses_vl
171: where system_status_type = 'AMS_EVENT_REG_STATUS'
172: and system_status_code = l_system_status_code
173: and default_flag = 'Y';
174: