APPS.IGS_AD_VAL_ASE dependencies on IGS_AD_AUS_SEC_ED_SC

Line 73: -- Validate that state_cd = IGS_AD_AUS_SEC_ED_SC .state_cd

69: IGS_GE_MSG_STACK.ADD;
70: App_Exception.Raise_Exception;
71: END admp_val_ase_atstate;
72: --
73: -- Validate that state_cd = IGS_AD_AUS_SEC_ED_SC .state_cd
74: FUNCTION ADMP_VAL_ASE_SCSTATE(
75: p_state_cd IN VARCHAR2 ,
76: p_secondary_school_cd IN VARCHAR2 ,
77: p_message_name OUT NOCOPY VARCHAR2 )

Line 82: -- IGS_AD_AUS_SEC_ED_SC.state_cd.

78: RETURN BOOLEAN IS
79: gv_other_detail VARCHAR2(255);
80: BEGIN -- admp_val_ase_scstate
81: -- Validate that the IGS_AD_AUS_SEC_EDU.state_cd is the same as the
82: -- IGS_AD_AUS_SEC_ED_SC.state_cd.
83: DECLARE
84: v_state_cd IGS_AD_AUS_SEC_EDU.state_cd%TYPE DEFAULT NULL;
85: CURSOR c_ases IS
86: SELECT state_cd

Line 87: FROM IGS_AD_AUS_SEC_ED_SC

83: DECLARE
84: v_state_cd IGS_AD_AUS_SEC_EDU.state_cd%TYPE DEFAULT NULL;
85: CURSOR c_ases IS
86: SELECT state_cd
87: FROM IGS_AD_AUS_SEC_ED_SC
88: WHERE secondary_school_cd = p_secondary_school_cd;
89: BEGIN
90: p_message_name := Null;
91: IF p_secondary_school_cd IS NOT NULL THEN