APPS.IGS_EN_VAL_SCT dependencies on IGS_PS_GRP

Line 200: v_s_course_group_type IGS_PS_GRP_TYPE.s_course_group_type%TYPE;

196: v_message_name varchar2(30);
197: v_to_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
198: v_to_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
199: v_to_acai_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE;
200: v_s_course_group_type IGS_PS_GRP_TYPE.s_course_group_type%TYPE;
201: v_from_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
202: v_from_course_attempt_status
203: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
204: v_to_admission_appl_number

Line 224: cp_s_course_group_type IGS_PS_GRP_TYPE.s_course_group_type%TYPE,

220: FROM IGS_EN_STDNT_PS_ATT sca
221: WHERE sca.person_id = p_person_id AND
222: sca.course_cd = p_transfer_course_cd;
223: CURSOR c_cgm_cg_cgt(
224: cp_s_course_group_type IGS_PS_GRP_TYPE.s_course_group_type%TYPE,
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'

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 230: IGS_PS_GRP cg,

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
234: cgt.s_course_group_type = cp_s_course_group_type AND

Line 231: IGS_PS_GRP_TYPE cgt

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
234: cgt.s_course_group_type = cp_s_course_group_type AND
235: cg.course_group_cd = cgm.course_group_cd 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