APPS.IGS_EN_ELGBL_OVERRIDE dependencies on IGS_PE_PRSID_GRP_MEM

Line 149: FROM igs_pe_prsid_grp_mem pig

145: WHERE (p_person_id IS NULL OR
146: sca.person_id = p_person_id) AND
147: (p_person_id_group IS NULL OR
148: EXISTS ( SELECT 'x'
149: FROM igs_pe_prsid_grp_mem pig
150: WHERE pig.group_id = p_person_id_group AND
151: pig.person_id = sca.person_id)) AND
152: sca.course_cd LIKE NVL(p_course_cd,'%') AND
153: igs_en_gen_011.match_term_sca_params (