APPS.IGS_AD_VAL_AUOS dependencies on IGS_LOOKUPS_VIEW

Line 54: FROM IGS_LOOKUPS_VIEW saos

50: DECLARE
51: v_saos_exists VARCHAR2(1);
52: CURSOR c_saos IS
53: SELECT 'X'
54: FROM IGS_LOOKUPS_VIEW saos
55: WHERE saos.lookup_type = 'ADM_OUTCOME_STATUS' AND
56: saos.lookup_code = p_s_adm_outcome_status AND
57: saos.unit_outcome_ind <> 'Y';
58: BEGIN