APPS.IGF_SL_GEN dependencies on IGS_AD_PS_APPL_INST

Line 1320: IGS_AD_PS_APPL_INST applinst,

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
1324: AND igsl2.adm_outcome_status = applinst.adm_outcome_status

Line 1338: igs_ad_ps_appl_inst applinst,

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
1342: AND appl.person_id = applinst.person_id