APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_HE_CODE_MAP_VAL

Line 471: l_hesa_special_student igs_he_code_map_val.map1%TYPE ;

467:
468:
469: l_course_cat igs_ps_categorise.course_cat%TYPE ;
470: l_course_group_cd igs_ps_grp_mbr.course_group_cd%TYPE ;
471: l_hesa_special_student igs_he_code_map_val.map1%TYPE ;
472: l_ad_special_student igs_he_code_map_val.map1%TYPE ;
473: l_dummy VARCHAR2(50);
474: l_dormant BOOLEAN := FALSE;
475:

Line 472: l_ad_special_student igs_he_code_map_val.map1%TYPE ;

468:
469: l_course_cat igs_ps_categorise.course_cat%TYPE ;
470: l_course_group_cd igs_ps_grp_mbr.course_group_cd%TYPE ;
471: l_hesa_special_student igs_he_code_map_val.map1%TYPE ;
472: l_ad_special_student igs_he_code_map_val.map1%TYPE ;
473: l_dummy VARCHAR2(50);
474: l_dormant BOOLEAN := FALSE;
475:
476: --smaddali added these cursors for bug#3166126

Line 794: l_hesa_study_location igs_he_code_map_val.map1%TYPE ;

790: OR only IS NOT NULL)
791: AND param_type IN ( 'ORG_UNIT' ,'PROGRAM_YEAR','OUTSIDE_UK','FE')
792: ORDER BY param_type;
793:
794: l_hesa_study_location igs_he_code_map_val.map1%TYPE ;
795: l_dummy VARCHAR2(50);
796:
797: --smaddali added these variable declarations for bug 2483523
798: l_oss_value_64 igs_he_ex_rn_dat_fd.value%TYPE ;