APPS.IGS_AD_VAL_ACA dependencies on IGS_PS_GRP

Line 252: cp_version_number IGS_PS_GRP_MBR.version_number%TYPE) IS

248: FROM IGS_EN_STDNT_PS_ATT
249: WHERE person_id = p_person_id AND
250: course_cd = p_transfer_course_cd;
251: CURSOR c_get_course_group_cd (
252: cp_version_number IGS_PS_GRP_MBR.version_number%TYPE) IS
253: SELECT cgr.course_group_cd
254: FROM IGS_PS_GRP_MBR cgm,
255: IGS_PS_GRP cgr,
256: IGS_PS_GRP_TYPE cgt

Line 254: FROM IGS_PS_GRP_MBR cgm,

250: course_cd = p_transfer_course_cd;
251: CURSOR c_get_course_group_cd (
252: cp_version_number IGS_PS_GRP_MBR.version_number%TYPE) IS
253: SELECT cgr.course_group_cd
254: FROM IGS_PS_GRP_MBR cgm,
255: IGS_PS_GRP cgr,
256: IGS_PS_GRP_TYPE cgt
257: WHERE cgm.course_cd = p_transfer_course_cd AND
258: cgm.version_number = cp_version_number AND

Line 255: IGS_PS_GRP cgr,

251: CURSOR c_get_course_group_cd (
252: cp_version_number IGS_PS_GRP_MBR.version_number%TYPE) IS
253: SELECT cgr.course_group_cd
254: FROM IGS_PS_GRP_MBR cgm,
255: IGS_PS_GRP cgr,
256: IGS_PS_GRP_TYPE cgt
257: WHERE cgm.course_cd = p_transfer_course_cd AND
258: cgm.version_number = cp_version_number AND
259: cgm.course_group_cd = cgr.course_group_cd AND

Line 256: IGS_PS_GRP_TYPE cgt

252: cp_version_number IGS_PS_GRP_MBR.version_number%TYPE) IS
253: SELECT cgr.course_group_cd
254: FROM IGS_PS_GRP_MBR cgm,
255: IGS_PS_GRP cgr,
256: IGS_PS_GRP_TYPE cgt
257: WHERE cgm.course_cd = p_transfer_course_cd AND
258: cgm.version_number = cp_version_number AND
259: cgm.course_group_cd = cgr.course_group_cd AND
260: cgr.course_group_type = cgt.course_group_type AND

Line 262: CURSOR c_cgm ( cp_course_cd IGS_PS_GRP_MBR.course_cd%TYPE,

258: cgm.version_number = cp_version_number AND
259: cgm.course_group_cd = cgr.course_group_cd AND
260: cgr.course_group_type = cgt.course_group_type AND
261: cgt.s_course_group_type = 'ADMTRANSFR';
262: CURSOR c_cgm ( cp_course_cd IGS_PS_GRP_MBR.course_cd%TYPE,
263: cp_version_number IGS_PS_GRP_MBR.version_number%TYPE,
264: cp_course_group_cd IGS_PS_GRP_MBR.course_group_cd%TYPE) IS
265: SELECT 'x'
266: FROM IGS_PS_GRP_MBR

Line 263: cp_version_number IGS_PS_GRP_MBR.version_number%TYPE,

259: cgm.course_group_cd = cgr.course_group_cd AND
260: cgr.course_group_type = cgt.course_group_type AND
261: cgt.s_course_group_type = 'ADMTRANSFR';
262: CURSOR c_cgm ( cp_course_cd IGS_PS_GRP_MBR.course_cd%TYPE,
263: cp_version_number IGS_PS_GRP_MBR.version_number%TYPE,
264: cp_course_group_cd IGS_PS_GRP_MBR.course_group_cd%TYPE) IS
265: SELECT 'x'
266: FROM IGS_PS_GRP_MBR
267: WHERE course_cd = cp_course_cd AND

Line 264: cp_course_group_cd IGS_PS_GRP_MBR.course_group_cd%TYPE) IS

260: cgr.course_group_type = cgt.course_group_type AND
261: cgt.s_course_group_type = 'ADMTRANSFR';
262: CURSOR c_cgm ( cp_course_cd IGS_PS_GRP_MBR.course_cd%TYPE,
263: cp_version_number IGS_PS_GRP_MBR.version_number%TYPE,
264: cp_course_group_cd IGS_PS_GRP_MBR.course_group_cd%TYPE) IS
265: SELECT 'x'
266: FROM IGS_PS_GRP_MBR
267: WHERE course_cd = cp_course_cd AND
268: version_number = cp_version_number AND

Line 266: FROM IGS_PS_GRP_MBR

262: CURSOR c_cgm ( cp_course_cd IGS_PS_GRP_MBR.course_cd%TYPE,
263: cp_version_number IGS_PS_GRP_MBR.version_number%TYPE,
264: cp_course_group_cd IGS_PS_GRP_MBR.course_group_cd%TYPE) IS
265: SELECT 'x'
266: FROM IGS_PS_GRP_MBR
267: WHERE course_cd = cp_course_cd AND
268: version_number = cp_version_number AND
269: course_group_cd = cp_course_group_cd;
270: BEGIN