APPS.IGS_AD_VAL_AUOS dependencies on IGS_LOOKUP_VALUES

Line 15: FROM IGS_LOOKUP_values saos

11: DECLARE
12: v_closed_ind VARCHAR(1);
13: CURSOR c_saos IS
14: SELECT saos.closed_ind
15: FROM IGS_LOOKUP_values saos
16: WHERE saos.lookup_code = p_s_adm_outcome_status
17: AND saos.lookup_type = 'ADM_OUTCOME_STATUS';
18: BEGIN
19: --- Set the default message number