APPS.OZF_UTILITY_PVT dependencies on AMS_USER_STATUSES_VL

Line 1749: FROM ams_user_statuses_vl

1745: l_status_code VARCHAR2(30);
1746:
1747: CURSOR c_status_code IS
1748: SELECT system_status_code
1749: FROM ams_user_statuses_vl
1750: WHERE user_status_id = p_user_status_id
1751: AND enabled_flag = 'Y';
1752:
1753: BEGIN

Line 1782: FROM ams_user_statuses_vl

1778: l_status_id NUMBER;
1779:
1780: CURSOR c_status_id IS
1781: SELECT user_status_id
1782: FROM ams_user_statuses_vl
1783: WHERE system_status_type = p_status_type
1784: AND system_status_code = p_status_code
1785: AND default_flag = 'Y'
1786: AND enabled_flag = 'Y';

Line 3181: SELECT name FROM ams_user_statuses_vl where user_status_id = p_user_status_id

3177: FUNCTION get_user_status_name(p_user_status_id IN NUMBER , p_system_status_type IN VARCHAR2)
3178: RETURN VARCHAR2
3179: IS
3180: CURSOR c_user_status_name (p_user_status_id NUMBER , p_system_status_type VARCHAR2)IS
3181: SELECT name FROM ams_user_statuses_vl where user_status_id = p_user_status_id
3182: AND system_status_type = p_system_status_type;
3183: l_user_status_name ams_user_statuses_tl.name%type;
3184: BEGIN
3185: OPEN c_user_status_name(p_user_status_id , p_system_status_type );