APPS.IGS_EN_VAL_SCT dependencies on IGS_PS_GRP_MBR

Line 229: FROM IGS_PS_GRP_MBR cgm,

225: cp_to_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
226: cp_from_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE)
227: IS
228: SELECT 'x'
229: FROM IGS_PS_GRP_MBR cgm,
230: IGS_PS_GRP cg,
231: IGS_PS_GRP_TYPE cgt
232: WHERE cgm.course_cd = p_course_cd AND
233: cgm.version_number = cp_to_version_number AND

Line 238: FROM IGS_PS_GRP_MBR cgm2

234: cgt.s_course_group_type = cp_s_course_group_type AND
235: cg.course_group_cd = cgm.course_group_cd AND
236: cg.course_group_type = cgt.course_group_type AND
237: EXISTS (SELECT 'x'
238: FROM IGS_PS_GRP_MBR cgm2
239: WHERE cgm2.course_cd = p_transfer_course_cd AND
240: cgm2.version_number = cp_from_version_number AND
241: cgm2.course_group_cd = cgm.course_group_cd);
242: BEGIN