APPS.IGS_IN_GEN_001 dependencies on IGS_AD_APPL

Line 29: FROM IGS_AD_APPL aa

25: cst_withdrawn CONSTANT VARCHAR2(12) := 'WITHDRAWN';
26: v_dummy VARCHAR2(1);
27: CURSOR c_aa IS
28: SELECT 'x'
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

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