APPS.IGS_IN_GEN_001 dependencies on IGS_AD_APPL_STAT

Line 33: FROM IGS_AD_APPL_STAT aas

29: FROM IGS_AD_APPL aa
30: WHERE aa.person_id = p_person_id AND
31: aa.adm_appl_status IN
32: (SELECT aas.adm_appl_status
33: FROM IGS_AD_APPL_STAT aas
34: WHERE aas.s_adm_appl_status NOT IN
35: (cst_completed,
36: cst_withdrawn));
37: BEGIN