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_CL_ORIG dependencies on IGF_AP_ISIR_MATCHED

Line 139: lv_dependency_status igf_ap_isir_matched_all.dependency_status%TYPE;

135:
136: SKIP_RECORD EXCEPTION;
137: g_debug_runtime_level NUMBER;
138:
139: lv_dependency_status igf_ap_isir_matched_all.dependency_status%TYPE;
140: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
141: lv_p_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
142: lv_s_license_number igf_ap_isir_matched_all.driver_license_number%TYPE;
143: lv_s_license_state igf_ap_isir_matched_all.driver_license_state%TYPE;

Line 140: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;

136: SKIP_RECORD EXCEPTION;
137: g_debug_runtime_level NUMBER;
138:
139: lv_dependency_status igf_ap_isir_matched_all.dependency_status%TYPE;
140: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
141: lv_p_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
142: lv_s_license_number igf_ap_isir_matched_all.driver_license_number%TYPE;
143: lv_s_license_state igf_ap_isir_matched_all.driver_license_state%TYPE;
144: lv_alien_reg_num igf_sl_lor_loc_all.s_alien_reg_num%TYPE; --pssahni 31-Jan-2005 changed %type from igf_ap_isir_matched_all to igf_sl_lor_loc_all

Line 141: lv_p_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;

137: g_debug_runtime_level NUMBER;
138:
139: lv_dependency_status igf_ap_isir_matched_all.dependency_status%TYPE;
140: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
141: lv_p_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
142: lv_s_license_number igf_ap_isir_matched_all.driver_license_number%TYPE;
143: lv_s_license_state igf_ap_isir_matched_all.driver_license_state%TYPE;
144: lv_alien_reg_num igf_sl_lor_loc_all.s_alien_reg_num%TYPE; --pssahni 31-Jan-2005 changed %type from igf_ap_isir_matched_all to igf_sl_lor_loc_all
145: lv_s_legal_res_state igf_ap_isir_matched_all.s_state_legal_residence%TYPE;

Line 142: lv_s_license_number igf_ap_isir_matched_all.driver_license_number%TYPE;

138:
139: lv_dependency_status igf_ap_isir_matched_all.dependency_status%TYPE;
140: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
141: lv_p_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
142: lv_s_license_number igf_ap_isir_matched_all.driver_license_number%TYPE;
143: lv_s_license_state igf_ap_isir_matched_all.driver_license_state%TYPE;
144: lv_alien_reg_num igf_sl_lor_loc_all.s_alien_reg_num%TYPE; --pssahni 31-Jan-2005 changed %type from igf_ap_isir_matched_all to igf_sl_lor_loc_all
145: lv_s_legal_res_state igf_ap_isir_matched_all.s_state_legal_residence%TYPE;
146: lv_s_legal_res_date DATE;

Line 143: lv_s_license_state igf_ap_isir_matched_all.driver_license_state%TYPE;

139: lv_dependency_status igf_ap_isir_matched_all.dependency_status%TYPE;
140: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
141: lv_p_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
142: lv_s_license_number igf_ap_isir_matched_all.driver_license_number%TYPE;
143: lv_s_license_state igf_ap_isir_matched_all.driver_license_state%TYPE;
144: lv_alien_reg_num igf_sl_lor_loc_all.s_alien_reg_num%TYPE; --pssahni 31-Jan-2005 changed %type from igf_ap_isir_matched_all to igf_sl_lor_loc_all
145: lv_s_legal_res_state igf_ap_isir_matched_all.s_state_legal_residence%TYPE;
146: lv_s_legal_res_date DATE;
147: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

Line 144: lv_alien_reg_num igf_sl_lor_loc_all.s_alien_reg_num%TYPE; --pssahni 31-Jan-2005 changed %type from igf_ap_isir_matched_all to igf_sl_lor_loc_all

140: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
141: lv_p_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
142: lv_s_license_number igf_ap_isir_matched_all.driver_license_number%TYPE;
143: lv_s_license_state igf_ap_isir_matched_all.driver_license_state%TYPE;
144: lv_alien_reg_num igf_sl_lor_loc_all.s_alien_reg_num%TYPE; --pssahni 31-Jan-2005 changed %type from igf_ap_isir_matched_all to igf_sl_lor_loc_all
145: lv_s_legal_res_state igf_ap_isir_matched_all.s_state_legal_residence%TYPE;
146: lv_s_legal_res_date DATE;
147: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
148: lv_s_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;

Line 145: lv_s_legal_res_state igf_ap_isir_matched_all.s_state_legal_residence%TYPE;

141: lv_p_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
142: lv_s_license_number igf_ap_isir_matched_all.driver_license_number%TYPE;
143: lv_s_license_state igf_ap_isir_matched_all.driver_license_state%TYPE;
144: lv_alien_reg_num igf_sl_lor_loc_all.s_alien_reg_num%TYPE; --pssahni 31-Jan-2005 changed %type from igf_ap_isir_matched_all to igf_sl_lor_loc_all
145: lv_s_legal_res_state igf_ap_isir_matched_all.s_state_legal_residence%TYPE;
146: lv_s_legal_res_date DATE;
147: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
148: lv_s_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
149: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

Line 1350: FROM igf_ap_fa_base_rec fabase, igf_ap_isir_matched isir

1346:
1347: CURSOR cur_isir_depend_status
1348: IS
1349: SELECT isir.dependency_status
1350: FROM igf_ap_fa_base_rec fabase, igf_ap_isir_matched isir
1351: WHERE isir.base_id = fabase.base_id
1352: AND fabase.person_id = loan_rec.student_id
1353: AND isir.payment_isir = 'Y'
1354: AND isir.system_record_type = 'ORIGINAL';