APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_PS_FIELD_STUDY

Line 2626: FROM igs_ps_field_study a,

2622:
2623: CURSOR c_sbj1 IS
2624: SELECT b.govt_field_of_study,
2625: a.percentage
2626: FROM igs_ps_field_study a,
2627: igs_ps_fld_of_study b
2628: WHERE a.course_cd = p_course_cd
2629: AND a.version_number = p_version_number
2630: AND a.major_field_ind = 'Y'

Line 2636: FROM igs_ps_field_study a,

2632:
2633: CURSOR c_sbj23 IS
2634: SELECT b.govt_field_of_study,
2635: a.percentage
2636: FROM igs_ps_field_study a,
2637: igs_ps_fld_of_study b
2638: WHERE a.course_cd = p_course_cd
2639: AND a.version_number = p_version_number
2640: AND a.major_field_ind = 'N'

Line 2645: l_percentage1 igs_ps_field_study.percentage%TYPE;

2641: AND a.field_of_study = b.field_of_study
2642: ORDER BY percentage DESC ;
2643:
2644: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
2645: l_percentage1 igs_ps_field_study.percentage%TYPE;
2646: l_percentage2 igs_ps_field_study.percentage%TYPE;
2647: l_percentage3 igs_ps_field_study.percentage%TYPE;
2648:
2649: BEGIN

Line 2646: l_percentage2 igs_ps_field_study.percentage%TYPE;

2642: ORDER BY percentage DESC ;
2643:
2644: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
2645: l_percentage1 igs_ps_field_study.percentage%TYPE;
2646: l_percentage2 igs_ps_field_study.percentage%TYPE;
2647: l_percentage3 igs_ps_field_study.percentage%TYPE;
2648:
2649: BEGIN
2650: -- Get Subject 1, Major

Line 2647: l_percentage3 igs_ps_field_study.percentage%TYPE;

2643:
2644: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
2645: l_percentage1 igs_ps_field_study.percentage%TYPE;
2646: l_percentage2 igs_ps_field_study.percentage%TYPE;
2647: l_percentage3 igs_ps_field_study.percentage%TYPE;
2648:
2649: BEGIN
2650: -- Get Subject 1, Major
2651: OPEN c_sbj1;