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