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

Line 230: lv_s_citizenship_status igf_ap_isir_matched.citizenship_status%TYPE;

226: to ope_id
227: ***************************************************************/
228:
229: lv_loan_status igf_sl_loans_all.loan_status%TYPE;
230: lv_s_citizenship_status igf_ap_isir_matched.citizenship_status%TYPE;
231: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
232: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
233: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
234: ln_disb_amt_count NUMBER(2);

Line 231: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;

227: ***************************************************************/
228:
229: lv_loan_status igf_sl_loans_all.loan_status%TYPE;
230: lv_s_citizenship_status igf_ap_isir_matched.citizenship_status%TYPE;
231: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
232: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
233: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
234: ln_disb_amt_count NUMBER(2);
235: ln_disb_ind_count NUMBER(2);

Line 232: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;

228:
229: lv_loan_status igf_sl_loans_all.loan_status%TYPE;
230: lv_s_citizenship_status igf_ap_isir_matched.citizenship_status%TYPE;
231: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
232: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
233: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
234: ln_disb_amt_count NUMBER(2);
235: ln_disb_ind_count NUMBER(2);
236: ln_disb_dates_count NUMBER(2);

Line 233: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;

229: lv_loan_status igf_sl_loans_all.loan_status%TYPE;
230: lv_s_citizenship_status igf_ap_isir_matched.citizenship_status%TYPE;
231: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
232: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
233: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
234: ln_disb_amt_count NUMBER(2);
235: ln_disb_ind_count NUMBER(2);
236: ln_disb_dates_count NUMBER(2);
237: l_phone VARCHAR2(100);

Line 360: FROM igf_ap_isir_matched isir

356: -- Cursor to fetch Student License No.,State and Citizenship Status
357:
358: CURSOR cur_isir_depend_status IS
359: SELECT isir.dependency_status
360: FROM igf_ap_isir_matched isir
361: WHERE isir.payment_isir = 'Y'
362: AND isir.system_record_type = 'ORIGINAL'
363: AND isir.base_id=lor_rec_temp.base_id;
364: