DBA Data[Home] [Help]

APPS.AMS_UTILITY_PVT dependencies on AMS_USER_STATUSES_VL

Line 1673: FROM ams_user_statuses_vl

1669: l_status_code VARCHAR2(30);
1670:
1671: CURSOR c_status_code IS
1672: SELECT system_status_code
1673: FROM ams_user_statuses_vl
1674: WHERE user_status_id = p_user_status_id
1675: AND enabled_flag = 'Y';
1676:
1677: BEGIN

Line 1706: FROM ams_user_statuses_vl

1702: l_status_id NUMBER;
1703:
1704: CURSOR c_status_id IS
1705: SELECT user_status_id
1706: FROM ams_user_statuses_vl
1707: WHERE system_status_type = p_status_type
1708: AND system_status_code = p_status_code
1709: AND default_flag = 'Y'
1710: AND enabled_flag = 'Y';