DBA Data[Home] [Help]

APPS.AMS_LIST_PURGE_PVT dependencies on AMS_USER_STATUSES_VL

Line 622: FROM ams_user_statuses_vl

618:
619:
620: CURSOR c_get_user_status_id ( c_status_code in varchar2) IS
621: SELECT user_status_id
622: FROM ams_user_statuses_vl
623: WHERE system_status_type = 'AMS_LIST_STATUS'
624: AND system_status_code = c_status_code
625: AND enabled_flag = 'Y'
626: AND default_flag = 'Y';