APPS.IGS_AS_NOTIFY_PKG dependencies on IGS_PE_PRSID_GRP_MEM

Line 78: FROM igs_pe_prsid_grp_mem pigm,

74: FROM igs_as_gpc_aca_stndg gas
75: WHERE spa.progression_status = gas.progression_status
76: AND gas.grading_period_cd = lp_grading_period_cd)
77: OR EXISTS (SELECT 'X'
78: FROM igs_pe_prsid_grp_mem pigm,
79: igs_as_gpc_pe_id_grp gpg
80: WHERE spa.person_id = pigm.person_id
81: AND pigm.group_id = gpg.group_id
82: AND gpg.grading_period_cd = lp_grading_period_cd)