APPS.IGF_SL_GEN dependencies on IGS_AD_APPL_ALL

Line 1309: FROM IGS_AD_APPL_ALL appl,

1305:
1306: -- get number of applications for the Person
1307: CURSOR cur_get_num_appl (p_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
1308: SELECT count(ADMISSION_APPL_NUMBER) num_of_appls
1309: FROM IGS_AD_APPL_ALL appl,
1310: IGS_AD_APPL_STAT_V stat
1311: WHERE appl.ADM_APPL_STATUS = stat.ADM_APPL_STATUS
1312: AND stat.S_ADM_APPL_STATUS <> 'WITHDRAWN'
1313: AND PERSON_ID = p_person_id;

Line 1319: FROM IGS_AD_APPL_ALL appl,

1315:
1316: -- get total number of application instances.
1317: CURSOR cur_get_num_applinst(p_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
1318: SELECT count(*) num_of_records
1319: FROM IGS_AD_APPL_ALL appl,
1320: IGS_AD_PS_APPL_INST applinst,
1321: IGS_AD_OU_STAT_V igsl2
1322: WHERE appl.person_id = applinst.person_id
1323: AND appl.admission_appl_number = applinst.admission_appl_number

Line 1337: igs_ad_appl_all appl,

1333: hz.party_id,
1334: count(*) NUM_OF_RECORDS
1335: FROM igs_ps_ver_all ps,
1336: hz_parties hz,
1337: igs_ad_appl_all appl,
1338: igs_ad_ps_appl_inst applinst,
1339: igs_ad_appl_stat_v igsl1,
1340: igs_ad_ou_stat_v igsl2
1341: WHERE ps.responsible_org_unit_cd = hz.party_number