APPS.IGS_AD_VAL_ASEAT dependencies on IGS_AD_TAC_AUSCED_AS

Line 10: -- Validate if IGS_AD_TAC_AUSCED_AS.tac_aus_scndry_edu_ass_type -- is closed.

6: p_message_name OUT NOCOPY VARCHAR2 )
7: RETURN BOOLEAN IS
8: gv_other_detail VARCHAR2(255);
9: BEGIN -- admp_val_taseatclose
10: -- Validate if IGS_AD_TAC_AUSCED_AS.tac_aus_scndry_edu_ass_type -- is closed.
11: DECLARE
12: v_closed_ind IGS_AD_TAC_AUSCED_AS.closed_ind%TYPE DEFAULT NULL;
13: CURSOR c_taseat IS
14: SELECT closed_ind

Line 12: v_closed_ind IGS_AD_TAC_AUSCED_AS.closed_ind%TYPE DEFAULT NULL;

8: gv_other_detail VARCHAR2(255);
9: BEGIN -- admp_val_taseatclose
10: -- Validate if IGS_AD_TAC_AUSCED_AS.tac_aus_scndry_edu_ass_type -- is closed.
11: DECLARE
12: v_closed_ind IGS_AD_TAC_AUSCED_AS.closed_ind%TYPE DEFAULT NULL;
13: CURSOR c_taseat IS
14: SELECT closed_ind
15: FROM IGS_AD_TAC_AUSCED_AS taseat
16: WHERE taseat.tac_aus_scndry_edu_ass_type =

Line 15: FROM IGS_AD_TAC_AUSCED_AS taseat

11: DECLARE
12: v_closed_ind IGS_AD_TAC_AUSCED_AS.closed_ind%TYPE DEFAULT NULL;
13: CURSOR c_taseat IS
14: SELECT closed_ind
15: FROM IGS_AD_TAC_AUSCED_AS taseat
16: WHERE taseat.tac_aus_scndry_edu_ass_type =
17: p_tac_aus_scndry_edu_ass_type;
18: BEGIN
19: p_message_name := Null;