APPS.IGS_HE_UCAS_TARIFF_PKG dependencies on IGS_PS_GRP_MBR

Line 62: CURSOR prg_group_mem_cur (cp_course_cd igs_ps_grp_mbr.course_cd%TYPE,

58: WHERE person_id = cp_person_id ;
59: l_person_number igs_pe_person.person_number%TYPE ;
60:
61: -- cursor to validate that the course is attached to the program group
62: CURSOR prg_group_mem_cur (cp_course_cd igs_ps_grp_mbr.course_cd%TYPE,
63: cp_version igs_ps_grp_mbr.version_number%TYPE) IS
64: SELECT 'X'
65: FROM igs_ps_grp_mbr
66: WHERE course_cd = cp_course_cd

Line 63: cp_version igs_ps_grp_mbr.version_number%TYPE) IS

59: l_person_number igs_pe_person.person_number%TYPE ;
60:
61: -- cursor to validate that the course is attached to the program group
62: CURSOR prg_group_mem_cur (cp_course_cd igs_ps_grp_mbr.course_cd%TYPE,
63: cp_version igs_ps_grp_mbr.version_number%TYPE) IS
64: SELECT 'X'
65: FROM igs_ps_grp_mbr
66: WHERE course_cd = cp_course_cd
67: AND version_number = cp_version

Line 65: FROM igs_ps_grp_mbr

61: -- cursor to validate that the course is attached to the program group
62: CURSOR prg_group_mem_cur (cp_course_cd igs_ps_grp_mbr.course_cd%TYPE,
63: cp_version igs_ps_grp_mbr.version_number%TYPE) IS
64: SELECT 'X'
65: FROM igs_ps_grp_mbr
66: WHERE course_cd = cp_course_cd
67: AND version_number = cp_version
68: AND course_group_cd = p_program_group;
69: