APPS.IGS_AD_GEN_008 dependencies on IGS_AD_APPL

Line 365: igs_ad_appl aa,

361: acaiv.attendance_type,
362: acaiv.adm_cal_type,
363: acaiv.adm_ci_sequence_number
364: FROM
365: igs_ad_appl aa,
366: igs_ad_ps_appl_inst acaiv, /* Replacing IGS_AD_PS_APPL_INST_APLINST_V with base tables Bug: 3150054 */
367: igs_ad_ps_appl aca
368: WHERE
369: acaiv.person_id = p_person_id AND

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;