APPS.IGS_AD_GEN_009 dependencies on IGS_AD_FEE_STAT

Line 118: FROM IGS_AD_FEE_STAT afs

114: -- for the given system admission fee status
115: DECLARE
116: CURSOR c_afs IS
117: SELECT afs.adm_fee_status
118: FROM IGS_AD_FEE_STAT afs
119: WHERE afs.s_adm_fee_status = p_s_adm_fee_status AND
120: afs.system_default_ind = 'Y' AND
121: afs.closed_ind = 'N';
122: v_adm_fee_status IGS_AD_FEE_STAT.adm_fee_status%TYPE := NULL;

Line 122: v_adm_fee_status IGS_AD_FEE_STAT.adm_fee_status%TYPE := NULL;

118: FROM IGS_AD_FEE_STAT afs
119: WHERE afs.s_adm_fee_status = p_s_adm_fee_status AND
120: afs.system_default_ind = 'Y' AND
121: afs.closed_ind = 'N';
122: v_adm_fee_status IGS_AD_FEE_STAT.adm_fee_status%TYPE := NULL;
123: BEGIN
124: FOR v_afs_rec IN c_afs LOOP
125: IF c_afs%ROWCOUNT > 1 THEN
126: v_adm_fee_status := NULL;