1142: from igs_ad_appl_all a,
1143: igs_ad_ps_appl_inst_all i,
1144: igs_ad_aplins_admreq r,
1145: igs_tr_item_all t,
1146: igs_tr_type_all ty
1147: where a.person_id = i.person_id
1148: and (p_person_id_group IS NOT NULL and
1149: a.person_id IN (SELECT person_id
1150: FROM igs_pe_prsid_grp_mem pgm
1179: from igs_ad_appl_all a,
1180: igs_ad_ps_appl_inst_all i,
1181: igs_ad_aplins_admreq r,
1182: igs_tr_item_all t,
1183: igs_tr_type_all ty
1184: where a.person_id = i.person_id
1185: and (p_person_id_group IS NOT NULL and
1186: a.person_id IN (SELECT person_id
1187: FROM igs_pe_prsid_grp_mem pgm