APPS.IGS_AD_GEN_008 dependencies on IGS_AD_APPL_STAT

Line 733: FROM IGS_AD_APPL_STAT aas

729: -- status for the given system admission application status
730: DECLARE
731: CURSOR c_aas IS
732: SELECT aas.adm_appl_status
733: FROM IGS_AD_APPL_STAT aas
734: WHERE aas.s_adm_appl_status = p_s_adm_appl_status AND
735: aas.system_default_ind = 'Y' AND
736: aas.closed_ind = 'N';
737: v_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE := NULL;

Line 737: v_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE := NULL;

733: FROM IGS_AD_APPL_STAT aas
734: WHERE aas.s_adm_appl_status = p_s_adm_appl_status AND
735: aas.system_default_ind = 'Y' AND
736: aas.closed_ind = 'N';
737: v_adm_appl_status IGS_AD_APPL_STAT.adm_appl_status%TYPE := NULL;
738: BEGIN
739: FOR v_aas_rec IN c_aas LOOP
740: IF c_aas%ROWCOUNT > 1 THEN
741: v_adm_appl_status := NULL;