APPS.AHL_UTILITY_PVT dependencies on AHL_USER_STATUSES_VL

Line 354: WHERE EXISTS (SELECT * FROM AHL_USER_STATUSES_VL

350: RETURN VARCHAR2
351: IS
352: CURSOR cur_usr_stat_det IS
353: SELECT 1 FROM DUAL
354: WHERE EXISTS (SELECT * FROM AHL_USER_STATUSES_VL
355: WHERE user_status_id = p_user_status_id
356: AND system_status_type = p_status_type
357: AND system_status_code = p_next_status
358: AND active_flag = 'Y');

Line 405: FROM AHL_USER_STATUSES_VL

401: CURSOR cur_user_stat (c_status_type IN VARCHAR2,
402: c_status_code IN VARCHAR2)
403: IS
404: SELECT system_status_code
405: FROM AHL_USER_STATUSES_VL
406: WHERE system_status_type = c_status_type
407: AND name = c_status_code;
408: l_dummy NUMBER;
409: l_c_system_status VARCHAR2(30);