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.

APPS.IGF_SL_DL_CHG_ORIG dependencies on IGF_AP_ISIR_MATCHED

Line 139: l_driver_license_number igf_ap_isir_matched.driver_license_number%TYPE;

135: lv_bool BOOLEAN;
136: l_disb BOOLEAN := TRUE; -- ## Variable for disbursement calculations
137: l_disb_loc BOOLEAN := FALSE; -- ## Variable for disbursement calculations
138:
139: l_driver_license_number igf_ap_isir_matched.driver_license_number%TYPE;
140: l_driver_license_state igf_ap_isir_matched.driver_license_state%TYPE;
141: l_citizenship_status igf_ap_isir_matched.citizenship_status%TYPE;
142: l_alien_reg_number igf_ap_isir_matched.alien_reg_number%TYPE;
143: l_dependency_status igf_ap_isir_matched.dependency_status%TYPE;

Line 140: l_driver_license_state igf_ap_isir_matched.driver_license_state%TYPE;

136: l_disb BOOLEAN := TRUE; -- ## Variable for disbursement calculations
137: l_disb_loc BOOLEAN := FALSE; -- ## Variable for disbursement calculations
138:
139: l_driver_license_number igf_ap_isir_matched.driver_license_number%TYPE;
140: l_driver_license_state igf_ap_isir_matched.driver_license_state%TYPE;
141: l_citizenship_status igf_ap_isir_matched.citizenship_status%TYPE;
142: l_alien_reg_number igf_ap_isir_matched.alien_reg_number%TYPE;
143: l_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
144: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;

Line 141: l_citizenship_status igf_ap_isir_matched.citizenship_status%TYPE;

137: l_disb_loc BOOLEAN := FALSE; -- ## Variable for disbursement calculations
138:
139: l_driver_license_number igf_ap_isir_matched.driver_license_number%TYPE;
140: l_driver_license_state igf_ap_isir_matched.driver_license_state%TYPE;
141: l_citizenship_status igf_ap_isir_matched.citizenship_status%TYPE;
142: l_alien_reg_number igf_ap_isir_matched.alien_reg_number%TYPE;
143: l_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
144: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
145: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;

Line 142: l_alien_reg_number igf_ap_isir_matched.alien_reg_number%TYPE;

138:
139: l_driver_license_number igf_ap_isir_matched.driver_license_number%TYPE;
140: l_driver_license_state igf_ap_isir_matched.driver_license_state%TYPE;
141: l_citizenship_status igf_ap_isir_matched.citizenship_status%TYPE;
142: l_alien_reg_number igf_ap_isir_matched.alien_reg_number%TYPE;
143: l_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
144: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
145: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
146: student_dtl_cur igf_sl_gen.person_dtl_cur;

Line 143: l_dependency_status igf_ap_isir_matched.dependency_status%TYPE;

139: l_driver_license_number igf_ap_isir_matched.driver_license_number%TYPE;
140: l_driver_license_state igf_ap_isir_matched.driver_license_state%TYPE;
141: l_citizenship_status igf_ap_isir_matched.citizenship_status%TYPE;
142: l_alien_reg_number igf_ap_isir_matched.alien_reg_number%TYPE;
143: l_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
144: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
145: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
146: student_dtl_cur igf_sl_gen.person_dtl_cur;
147: parent_dtl_cur igf_sl_gen.person_dtl_cur;

Line 229: FROM igf_ap_fa_base_rec fabase,igf_ap_isir_matched isir

225:
226: CURSOR cur_isir_depend_status(l_base_id igf_ap_fa_base_rec.base_id%TYPE)
227: IS
228: SELECT isir.dependency_status
229: FROM igf_ap_fa_base_rec fabase,igf_ap_isir_matched isir
230: WHERE isir.isir_id = fabase.payment_isir_id
231: AND fabase.base_id = l_base_id;
232:
233: -- ## Cursor to Retrieve the disburesment records