APPS.IGS_AS_GEN_004 dependencies on IGS_AS_GPC_PE_ID_GRP

Line 877: igs_as_gpc_pe_id_grp gpg

873: AND sca.course_cd = sua.course_cd
874: AND sca.progression_status = gas.progression_status)
875: OR EXISTS ( SELECT 'x'
876: FROM igs_pe_prsid_grp_mem pigm,
877: igs_as_gpc_pe_id_grp gpg
878: WHERE sua.person_id = pigm.person_id
879: AND pigm.GROUP_ID = gpg.GROUP_ID)
880: OR EXISTS ( SELECT 'x'
881: FROM igs_as_gpc_cls_stndg gcs

Line 945: igs_as_gpc_pe_id_grp gpg

941: AND sca.course_cd = sua.course_cd
942: AND sca.progression_status = gas.progression_status)
943: OR EXISTS ( SELECT 'x'
944: FROM igs_pe_prsid_grp_mem pigm,
945: igs_as_gpc_pe_id_grp gpg
946: WHERE sua.person_id = pigm.person_id
947: AND pigm.GROUP_ID = gpg.GROUP_ID)
948: OR EXISTS ( SELECT 'x'
949: FROM igs_as_gpc_cls_stndg gcs