APPS.OZF_UTILITY_PVT dependencies on AMS_USER_STATUSES_VL

Line 1724: FROM ams_user_statuses_vl

1720: l_status_code VARCHAR2(30);
1721:
1722: CURSOR c_status_code IS
1723: SELECT system_status_code
1724: FROM ams_user_statuses_vl
1725: WHERE user_status_id = p_user_status_id
1726: AND enabled_flag = 'Y';
1727:
1728: BEGIN

Line 1757: FROM ams_user_statuses_vl

1753: l_status_id NUMBER;
1754:
1755: CURSOR c_status_id IS
1756: SELECT user_status_id
1757: FROM ams_user_statuses_vl
1758: WHERE system_status_type = p_status_type
1759: AND system_status_code = p_status_code
1760: AND default_flag = 'Y'
1761: AND enabled_flag = 'Y';

Line 3159: SELECT name FROM ams_user_statuses_vl where user_status_id = p_user_status_id

3155: FUNCTION get_user_status_name(p_user_status_id IN NUMBER , p_system_status_type IN VARCHAR2)
3156: RETURN VARCHAR2
3157: IS
3158: CURSOR c_user_status_name (p_user_status_id NUMBER , p_system_status_type VARCHAR2)IS
3159: SELECT name FROM ams_user_statuses_vl where user_status_id = p_user_status_id
3160: AND system_status_type = p_system_status_type;
3161: l_user_status_name ams_user_statuses_tl.name%type;
3162: BEGIN
3163: OPEN c_user_status_name(p_user_status_id , p_system_status_type );