APPS.AHL_UTILITY_PVT dependencies on AHL_STATUS_ORDER_RULES

Line 396: WHERE EXISTS (SELECT * FROM AHL_STATUS_ORDER_RULES

392: IS
393: -- Cursor to check next status code is valid
394: CURSOR cur_stat_det IS
395: SELECT 1 FROM DUAL
396: WHERE EXISTS (SELECT * FROM AHL_STATUS_ORDER_RULES
397: WHERE system_status_type = p_status_type
398: AND current_status_code = p_current_status
399: AND next_status_code = p_next_status);
400: -- Cursor to get system status code

Line 475: SELECT '1' FROM AHL_STATUS_ORDER_RULES

471: CURSOR cur_stat_det (c_status_type IN VARCHAR2,
472: c_current_status IN VARCHAR2,
473: c_next_status IN VARCHAR2)
474: IS
475: SELECT '1' FROM AHL_STATUS_ORDER_RULES
476: WHERE system_status_type = c_status_type
477: AND current_status_code = c_current_status
478: AND next_status_code = c_next_status;
479: l_dummy NUMBER;