APPS.IGS_EN_VAL_AUSL dependencies on IGS_AD_ADM_UNIT_STAT

Line 21: v_unit_att_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;

17: RETURN BOOLEAN AS
18: BEGIN
19: DECLARE
20:
21: v_unit_att_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;
22: CURSOR c_aus IS
23: SELECT unit_attempt_status
24: FROM IGS_AD_ADM_UNIT_STAT
25: WHERE administrative_unit_status = p_aus;

Line 24: FROM IGS_AD_ADM_UNIT_STAT

20:
21: v_unit_att_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;
22: CURSOR c_aus IS
23: SELECT unit_attempt_status
24: FROM IGS_AD_ADM_UNIT_STAT
25: WHERE administrative_unit_status = p_aus;
26: BEGIN
27: -- Check if the IGS_AD_ADM_UNIT_STAT is closed
28: p_message_name := null;

Line 27: -- Check if the IGS_AD_ADM_UNIT_STAT is closed

23: SELECT unit_attempt_status
24: FROM IGS_AD_ADM_UNIT_STAT
25: WHERE administrative_unit_status = p_aus;
26: BEGIN
27: -- Check if the IGS_AD_ADM_UNIT_STAT is closed
28: p_message_name := null;
29: OPEN c_aus;
30: FETCH c_aus INTO v_unit_att_status;
31: IF (c_aus%NOTFOUND) THEN