APPS.IGS_EN_VAL_PCGE dependencies on IGS_PS_GRP

Line 79: FROM IGS_PS_GRP

75:
76: v_closed_ind VARCHAR2(1);
77: CURSOR c_course_group_cd IS
78: SELECT closed_ind
79: FROM IGS_PS_GRP
80: WHERE course_group_cd = p_course_group_cd;
81: BEGIN
82: -- Check if the IGS_PS_COURSE group code is closed
83: p_message_name := null;

Line 128: IGS_PS_GRP_MBR cgm

124: v_validate_failed BOOLEAN DEFAULT FALSE;
125: CURSOR c_get_course_cd IS
126: SELECT sca.course_cd
127: FROM IGS_EN_STDNT_PS_ATT sca,
128: IGS_PS_GRP_MBR cgm
129: WHERE sca.person_id = p_person_id AND
130: sca.course_attempt_status IN
131: ('ENROLLED', 'INACTIVE', 'INTERMIT') AND
132: sca.course_cd = cgm.course_cd AND