APPS.IGF_AW_FISAP_PKG dependencies on IGF_AP_ISIR_MATCHED

Line 119: FROM IGF_AP_ISIR_MATCHED

115:
116: CURSOR cur_citizenship_requirement(cp_base_id IN NUMBER) IS
117: SELECT DECODE(ins_match_flag, 'Y', 'Y', 'N') primary_dhs,
118: DECODE(sec_ins_match_flag, 'Y', 'Y', 'N') sec_dhs
119: FROM IGF_AP_ISIR_MATCHED
120: WHERE base_id = cp_base_id
121: AND active_isir = 'Y';
122: rec_citizenship_requirement cur_citizenship_requirement%ROWTYPE;
123:

Line 476: FROM IGF_AP_ISIR_MATCHED isir

472: isir.isir_id,
473: DECODE(isir.auto_zero_efc, 'Y', 'Y', 'N') auto_zero_efc,
474: isir.total_income,
475: isir.student_total_income
476: FROM IGF_AP_ISIR_MATCHED isir
477: WHERE isir.base_id = cp_base_id
478: AND isir.active_isir = 'Y';
479: rec_isir_dtls cur_isir_dtls%ROWTYPE;
480:

Line 664: -- irrespective of the column value in IGF_AP_ISIR_MATCHED table.

660: lv_career_level := get_student_career_level(rec_student.base_id);
661: IF lv_career_level = 'GRAD_PROF' THEN
662: -- If the student's career level is "Graduate/Professional" then
663: -- consider his dependency status as "Independent"
664: -- irrespective of the column value in IGF_AP_ISIR_MATCHED table.
665:
666: -- Override student's dependency status to Independent
667: lv_dependency_status := 'I';
668: END IF;