APPS.IGS_HE_PROG_TRANSFER_PKG dependencies on IGS_PS_AWARD

Line 179: -- Cursor to retrieve default program award for the passed program from IGS_PS_AWARD

175: attendance_mode = v_u_old_attendance_mode AND
176: attendance_type = v_u_old_attendance_type;
177: c_old_poous_rec c_old_poous%ROWTYPE ;
178:
179: -- Cursor to retrieve default program award for the passed program from IGS_PS_AWARD
180: -- that will be validated.
181: CURSOR c_prg_awd( cp_course_cd igs_he_st_prog_all.course_cd%TYPE,
182: cp_version_number igs_he_st_prog_all.version_number%TYPE) IS
183: SELECT map1

Line 184: FROM igs_ps_award, igs_he_code_map_val

180: -- that will be validated.
181: CURSOR c_prg_awd( cp_course_cd igs_he_st_prog_all.course_cd%TYPE,
182: cp_version_number igs_he_st_prog_all.version_number%TYPE) IS
183: SELECT map1
184: FROM igs_ps_award, igs_he_code_map_val
185: WHERE course_cd = cp_course_cd AND
186: version_number = cp_version_number AND
187: closed_ind = 'N' AND
188: map2 = award_cd AND

Line 427: --FETCH Values for old records from IGS_HE_POOUS_ALL, IGS_PS_AWARD, IGS_FI_FND_SRC_RSTN

423: ELSE
424:
425: close c_old_susa;
426:
427: --FETCH Values for old records from IGS_HE_POOUS_ALL, IGS_PS_AWARD, IGS_FI_FND_SRC_RSTN
428: OPEN c_old_poous;
429: FETCH c_old_poous INTO c_old_poous_rec;
430: CLOSE c_old_poous;
431:

Line 444: --FETCH Values for new records from IGS_HE_POOUS_ALL, IGS_PS_AWARD, IGS_FI_FND_SRC_RSTN

440: OPEN c_fnd_src_rstn(p_old_course_cd,v_u_old_version_number);
441: FETCH c_fnd_src_rstn INTO v_old_prg_funding_source;
442: CLOSE c_fnd_src_rstn;
443:
444: --FETCH Values for new records from IGS_HE_POOUS_ALL, IGS_PS_AWARD, IGS_FI_FND_SRC_RSTN
445: OPEN c_new_poous;
446: FETCH c_new_poous INTO c_new_poous_rec;
447: CLOSE c_new_poous;
448:

Line 774: -- Cursor to retrieve record values for award code from IGS_PS_AWARD

770: FROM igs_en_stdnt_ps_att
771: WHERE person_id = p_person_id AND
772: course_cd = p_new_course_cd;
773:
774: -- Cursor to retrieve record values for award code from IGS_PS_AWARD
775: CURSOR c_awardcode (cp_course_cd igs_ps_award.course_cd%TYPE ,
776: cp_version_number igs_ps_award.version_number%TYPE) IS
777: SELECT map1
778: FROM igs_ps_award , igs_he_code_map_val

Line 775: CURSOR c_awardcode (cp_course_cd igs_ps_award.course_cd%TYPE ,

771: WHERE person_id = p_person_id AND
772: course_cd = p_new_course_cd;
773:
774: -- Cursor to retrieve record values for award code from IGS_PS_AWARD
775: CURSOR c_awardcode (cp_course_cd igs_ps_award.course_cd%TYPE ,
776: cp_version_number igs_ps_award.version_number%TYPE) IS
777: SELECT map1
778: FROM igs_ps_award , igs_he_code_map_val
779: WHERE course_cd = cp_course_cd AND

Line 776: cp_version_number igs_ps_award.version_number%TYPE) IS

772: course_cd = p_new_course_cd;
773:
774: -- Cursor to retrieve record values for award code from IGS_PS_AWARD
775: CURSOR c_awardcode (cp_course_cd igs_ps_award.course_cd%TYPE ,
776: cp_version_number igs_ps_award.version_number%TYPE) IS
777: SELECT map1
778: FROM igs_ps_award , igs_he_code_map_val
779: WHERE course_cd = cp_course_cd AND
780: version_number = cp_version_number AND

Line 778: FROM igs_ps_award , igs_he_code_map_val

774: -- Cursor to retrieve record values for award code from IGS_PS_AWARD
775: CURSOR c_awardcode (cp_course_cd igs_ps_award.course_cd%TYPE ,
776: cp_version_number igs_ps_award.version_number%TYPE) IS
777: SELECT map1
778: FROM igs_ps_award , igs_he_code_map_val
779: WHERE course_cd = cp_course_cd AND
780: version_number = cp_version_number AND
781: closed_ind = 'N' AND
782: map2 = award_cd AND