APPS.IGF_SL_DL_LI_IMP_PKG dependencies on IGF_SL_LOR_LOC_ALL

Line 1904: igf_sl_lor_loc_all table.

1900: The DUNS_BORW_LENDER_ID
1901: DUNS_GUARNT_ID
1902: DUNS_LENDER_ID
1903: DUNS_RECIP_ID columns are osboleted from the
1904: igf_sl_lor_loc_all table.
1905: -----------------------------------------------------------------------------------
1906: || veramach 23-SEP-2003 Bug 3104228:
1907: || 1. Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
1908: || cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,

Line 1963: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

1959:
1960: l_student_license cur_isir_depend_status%ROWTYPE;
1961:
1962: ln_row_id ROWID;
1963: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
1964: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
1965: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
1966: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
1967: lv_s_citizenship_status VARCHAR2(30);

Line 1964: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

1960: l_student_license cur_isir_depend_status%ROWTYPE;
1961:
1962: ln_row_id ROWID;
1963: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
1964: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
1965: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
1966: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
1967: lv_s_citizenship_status VARCHAR2(30);
1968: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;

Line 2400: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

2396: l_student_license cur_isir_depend_status%ROWTYPE;
2397:
2398: ln_rowid ROWID;
2399: ln_pnpp_id NUMBER;
2400: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
2401: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
2402: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
2403: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
2404: lv_s_citizenship_status VARCHAR2(30);

Line 2401: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

2397:
2398: ln_rowid ROWID;
2399: ln_pnpp_id NUMBER;
2400: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
2401: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
2402: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
2403: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
2404: lv_s_citizenship_status VARCHAR2(30);
2405: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;

Line 2860: FROM igf_sl_lor_loc_all

2856:
2857: CURSOR c_lor_loc(cp_orig_id NUMBER)
2858: IS
2859: SELECT rowid
2860: FROM igf_sl_lor_loc_all
2861: WHERE origination_id = cp_orig_id;
2862:
2863: l_lor_loc c_lor_loc%ROWTYPE;
2864: