APPS.IGS_HE_PROG_TRANSFER_PKG dependencies on IGS_PS_FIELD_STUDY

Line 750: v_old_tmp_prgfldstudy igs_ps_field_study.field_of_study%TYPE;

746: v_tariff_score igs_he_st_spa_ut_all.tariff_score%TYPE;
747: v_ut_rowid VARCHAR2(25);
748:
749: -- Variables to hold old and new values from other tables for record.
750: v_old_tmp_prgfldstudy igs_ps_field_study.field_of_study%TYPE;
751: v_new_tmp_prgfldstudy igs_ps_field_study.field_of_study%TYPE;
752:
753: -- Variables to hold old record unique key values
754: v_u_old_version_number igs_en_stdnt_ps_att.version_number%TYPE;

Line 751: v_new_tmp_prgfldstudy igs_ps_field_study.field_of_study%TYPE;

747: v_ut_rowid VARCHAR2(25);
748:
749: -- Variables to hold old and new values from other tables for record.
750: v_old_tmp_prgfldstudy igs_ps_field_study.field_of_study%TYPE;
751: v_new_tmp_prgfldstudy igs_ps_field_study.field_of_study%TYPE;
752:
753: -- Variables to hold old record unique key values
754: v_u_old_version_number igs_en_stdnt_ps_att.version_number%TYPE;
755: v_u_new_version_number igs_en_stdnt_ps_att.version_number%TYPE;

Line 757: v_u_old_program_fld_study igs_ps_field_study.field_of_study%TYPE;

753: -- Variables to hold old record unique key values
754: v_u_old_version_number igs_en_stdnt_ps_att.version_number%TYPE;
755: v_u_new_version_number igs_en_stdnt_ps_att.version_number%TYPE;
756: -- variables to hold old record program field of study values
757: v_u_old_program_fld_study igs_ps_field_study.field_of_study%TYPE;
758: v_u_new_program_fld_study igs_ps_field_study.field_of_study%TYPE;
759:
760: -- Cursor required to retrieve version_number which is required as unique key for another cursor.
761: CURSOR old_ukeyrec2 IS

Line 758: v_u_new_program_fld_study igs_ps_field_study.field_of_study%TYPE;

754: v_u_old_version_number igs_en_stdnt_ps_att.version_number%TYPE;
755: v_u_new_version_number igs_en_stdnt_ps_att.version_number%TYPE;
756: -- variables to hold old record program field of study values
757: v_u_old_program_fld_study igs_ps_field_study.field_of_study%TYPE;
758: v_u_new_program_fld_study igs_ps_field_study.field_of_study%TYPE;
759:
760: -- Cursor required to retrieve version_number which is required as unique key for another cursor.
761: CURSOR old_ukeyrec2 IS
762: SELECT version_number

Line 786: -- Cursor to retrieve old record values for program field of study record 2 from IGS_PS_FIELD_STUDY

782: map2 = award_cd AND
783: association_code = 'OSS_HESA_AWD_ASSOC'
784: ORDER BY default_ind DESC, map1 ASC ;
785:
786: -- Cursor to retrieve old record values for program field of study record 2 from IGS_PS_FIELD_STUDY
787: CURSOR c_old_prg_fldstudy IS
788: SELECT field_of_study
789: FROM igs_ps_field_study
790: WHERE course_cd = p_old_course_cd AND

Line 789: FROM igs_ps_field_study

785:
786: -- Cursor to retrieve old record values for program field of study record 2 from IGS_PS_FIELD_STUDY
787: CURSOR c_old_prg_fldstudy IS
788: SELECT field_of_study
789: FROM igs_ps_field_study
790: WHERE course_cd = p_old_course_cd AND
791: version_number = v_u_old_version_number AND
792: major_field_ind = 'Y';
793:

Line 794: -- Cursor to retrieve new record values for program field of study record 2 from IGS_PS_FIELD_STUDY

790: WHERE course_cd = p_old_course_cd AND
791: version_number = v_u_old_version_number AND
792: major_field_ind = 'Y';
793:
794: -- Cursor to retrieve new record values for program field of study record 2 from IGS_PS_FIELD_STUDY
795: CURSOR c_new_prg_fldstudy IS
796: SELECT field_of_study
797: FROM igs_ps_field_study
798: WHERE course_cd = p_new_course_cd AND

Line 797: FROM igs_ps_field_study

793:
794: -- Cursor to retrieve new record values for program field of study record 2 from IGS_PS_FIELD_STUDY
795: CURSOR c_new_prg_fldstudy IS
796: SELECT field_of_study
797: FROM igs_ps_field_study
798: WHERE course_cd = p_new_course_cd AND
799: version_number = v_u_new_version_number AND
800: major_field_ind = 'Y';
801: