APPS.OZF_UTILITY_PVT dependencies on AMS_USER_STATUSES_TL
Line 3183: l_user_status_name ams_user_statuses_tl.name%type;
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 );
3186: FETCH c_user_status_name INTO l_user_status_name;
3187: CLOSE c_user_status_name;