APPS.OZF_UTILITY_PVT dependencies on AMS_USER_STATUSES_TL

Line 3161: l_user_status_name ams_user_statuses_tl.name%type;

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 );
3164: FETCH c_user_status_name INTO l_user_status_name;
3165: CLOSE c_user_status_name;