APPS.IGS_AD_VAL_ACAIU dependencies on IGS_AD_APPL_STAT

Line 18: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;

14: BEGIN -- admp_val_acaiu_iud
15: -- This modules validates the insert/update/delete of
16: -- IGS_AD_PS_APLINSTUNT.
17: DECLARE
18: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
19: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
20: CURSOR c_aa_aas IS
21: SELECT aas.s_adm_appl_status
22: FROM IGS_AD_APPL aa,

Line 23: IGS_AD_APPL_STAT aas

19: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
20: CURSOR c_aa_aas IS
21: SELECT aas.s_adm_appl_status
22: FROM IGS_AD_APPL aa,
23: IGS_AD_APPL_STAT aas
24: WHERE
25: aa.person_id = p_person_id AND
26: aa.admission_appl_number= p_admission_appl_number AND
27: aa.adm_appl_status = aas.adm_appl_status;