APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_PS_AWARD

Line 2500: FROM igs_ps_award , igs_he_code_map_val

2496: ***************************************************************/
2497:
2498: CURSOR c_get_feq IS
2499: SELECT map1
2500: FROM igs_ps_award , igs_he_code_map_val
2501: WHERE course_cd = p_course_cd
2502: AND version_number = p_version_number
2503: AND closed_ind = 'N'
2504: AND map2 = award_cd

Line 2900: FROM igs_ps_award , igs_he_code_map_val

2896: --smaddali modified this cursor for bug 2392702
2897: -- smaddali Modified for bug#3360646, to remove default_ind=Y check and add default_ind in order by clause
2898: CURSOR c_prgawd IS
2899: SELECT map1
2900: FROM igs_ps_award , igs_he_code_map_val
2901: WHERE course_cd = p_course_cd
2902: AND version_number = p_version_number
2903: AND closed_ind = 'N'
2904: AND map2 = award_cd

Line 2909: l_oss_gen_qaim igs_ps_award.award_cd%TYPE;

2905: AND association_code = 'OSS_HESA_AWD_ASSOC'
2906: ORDER BY default_ind DESC, map1 ASC ;
2907:
2908: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
2909: l_oss_gen_qaim igs_ps_award.award_cd%TYPE;
2910:
2911: BEGIN
2912:
2913: IF p_spa_gen_qaim IS NOT NULL