eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_EN_SPA_AWD_AIM

Line 2130: FROM IGS_EN_SPA_AWD_AIM a

2126: -- smaddali added conndition a.complete_ind = 'Y', for HECR210 build bug#2874542
2127: CURSOR c_pr_approval_status
2128: IS
2129: SELECT COUNT(a.person_id)
2130: FROM IGS_EN_SPA_AWD_AIM a
2131: WHERE a.person_id = p_person_id
2132: AND a.course_cd = p_course_cd
2133: AND a.conferral_date BETWEEN p_enrl_start_dt and p_enrl_end_dt
2134: AND a.complete_ind = 'Y';

Line 2376: FROM igs_en_spa_awd_aim a ,

2372: SELECT a.award_cd,
2373: a.award_grade ,
2374: c.map1,
2375: a.grading_schema_cd
2376: FROM igs_en_spa_awd_aim a ,
2377: igs_he_code_map_val c
2378: WHERE a.person_id = p_person_id
2379: AND a.course_cd = p_course_cd
2380: AND a.conferral_date BETWEEN p_enrl_start_dt and p_enrl_end_dt

Line 2388: l_awd1 igs_en_spa_awd_aim.award_cd%TYPE;

2384: ORDER BY c.map1 ASC;
2385:
2386:
2387: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
2388: l_awd1 igs_en_spa_awd_aim.award_cd%TYPE;
2389: l_awd2 igs_en_spa_awd_aim.award_cd%TYPE;
2390: l_grade1 igs_en_spa_awd_aim.award_grade%TYPE;
2391: l_grade2 igs_en_spa_awd_aim.award_grade%TYPE;
2392: l_grading_schema1 igs_en_spa_awd_aim.grading_schema_cd%TYPE;

Line 2389: l_awd2 igs_en_spa_awd_aim.award_cd%TYPE;

2385:
2386:
2387: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
2388: l_awd1 igs_en_spa_awd_aim.award_cd%TYPE;
2389: l_awd2 igs_en_spa_awd_aim.award_cd%TYPE;
2390: l_grade1 igs_en_spa_awd_aim.award_grade%TYPE;
2391: l_grade2 igs_en_spa_awd_aim.award_grade%TYPE;
2392: l_grading_schema1 igs_en_spa_awd_aim.grading_schema_cd%TYPE;
2393: l_grading_schema2 igs_en_spa_awd_aim.grading_schema_cd%TYPE;

Line 2390: l_grade1 igs_en_spa_awd_aim.award_grade%TYPE;

2386:
2387: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
2388: l_awd1 igs_en_spa_awd_aim.award_cd%TYPE;
2389: l_awd2 igs_en_spa_awd_aim.award_cd%TYPE;
2390: l_grade1 igs_en_spa_awd_aim.award_grade%TYPE;
2391: l_grade2 igs_en_spa_awd_aim.award_grade%TYPE;
2392: l_grading_schema1 igs_en_spa_awd_aim.grading_schema_cd%TYPE;
2393: l_grading_schema2 igs_en_spa_awd_aim.grading_schema_cd%TYPE;
2394: l_classification1 igs_he_code_map_val.map1%TYPE;

Line 2391: l_grade2 igs_en_spa_awd_aim.award_grade%TYPE;

2387: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
2388: l_awd1 igs_en_spa_awd_aim.award_cd%TYPE;
2389: l_awd2 igs_en_spa_awd_aim.award_cd%TYPE;
2390: l_grade1 igs_en_spa_awd_aim.award_grade%TYPE;
2391: l_grade2 igs_en_spa_awd_aim.award_grade%TYPE;
2392: l_grading_schema1 igs_en_spa_awd_aim.grading_schema_cd%TYPE;
2393: l_grading_schema2 igs_en_spa_awd_aim.grading_schema_cd%TYPE;
2394: l_classification1 igs_he_code_map_val.map1%TYPE;
2395: l_classification2 igs_he_code_map_val.map1%TYPE;

Line 2392: l_grading_schema1 igs_en_spa_awd_aim.grading_schema_cd%TYPE;

2388: l_awd1 igs_en_spa_awd_aim.award_cd%TYPE;
2389: l_awd2 igs_en_spa_awd_aim.award_cd%TYPE;
2390: l_grade1 igs_en_spa_awd_aim.award_grade%TYPE;
2391: l_grade2 igs_en_spa_awd_aim.award_grade%TYPE;
2392: l_grading_schema1 igs_en_spa_awd_aim.grading_schema_cd%TYPE;
2393: l_grading_schema2 igs_en_spa_awd_aim.grading_schema_cd%TYPE;
2394: l_classification1 igs_he_code_map_val.map1%TYPE;
2395: l_classification2 igs_he_code_map_val.map1%TYPE;
2396:

Line 2393: l_grading_schema2 igs_en_spa_awd_aim.grading_schema_cd%TYPE;

2389: l_awd2 igs_en_spa_awd_aim.award_cd%TYPE;
2390: l_grade1 igs_en_spa_awd_aim.award_grade%TYPE;
2391: l_grade2 igs_en_spa_awd_aim.award_grade%TYPE;
2392: l_grading_schema1 igs_en_spa_awd_aim.grading_schema_cd%TYPE;
2393: l_grading_schema2 igs_en_spa_awd_aim.grading_schema_cd%TYPE;
2394: l_classification1 igs_he_code_map_val.map1%TYPE;
2395: l_classification2 igs_he_code_map_val.map1%TYPE;
2396:
2397: BEGIN

Line 2884: FROM igs_en_spa_awd_aim , igs_he_code_map_val

2880: -- smaddali Modified for bug#3360646, to check for dates overlapping with submission period
2881: -- and to exclude awards which are conferred before the submission start_date
2882: CURSOR c_spawd IS
2883: SELECT map1
2884: FROM igs_en_spa_awd_aim , igs_he_code_map_val
2885: WHERE person_id = p_person_id
2886: AND course_cd = p_course_cd
2887: AND start_dt <= NVL(p_enrl_end_dt,start_dt)
2888: AND ( end_dt IS NULL OR end_dt >= NVL(p_enrl_start_dt,end_dt) )