APPS.IGF_SL_CL_ORIG_ACK dependencies on IGF_SL_LOR_LOC

Line 73: -- igf_sl_lor_loc_all table.

69: -- b) The DUNS_BORW_LENDER_ID
70: -- DUNS_GUARNT_ID
71: -- DUNS_LENDER_ID
72: -- DUNS_RECIP_ID columns are osboleted from the
73: -- igf_sl_lor_loc_all table.
74: -- c) Removed the hard coded strings from the cursors.
75: ---------------------------------------------------------------------------------
76: -- gmuralid 03-07-2003 Bug 2995944 - Legacy Part 3 - FFELP Import
77: -- Added legacy record flag as parameter to

Line 2266: igf_sl_lor_loc_all table.

2262: b) The DUNS_BORW_LENDER_ID
2263: DUNS_GUARNT_ID
2264: DUNS_LENDER_ID
2265: DUNS_RECIP_ID columns are osboleted from the
2266: igf_sl_lor_loc_all table.
2267:
2268: bkkumar 18-sep-2003 Bug # 3104228 FA 122 Loan Enhancements
2269: In update_lor procedure changed the condition that
2270: loan status should be accepted if

Line 2879: FROM igf_sl_lor_loc lor_loc

2875: DECLARE
2876: CURSOR c_tbh_lor_rec
2877: IS
2878: SELECT lor_loc.*
2879: FROM igf_sl_lor_loc lor_loc
2880: WHERE loan_id = tbh_rec.loan_id FOR UPDATE OF loan_status NOWAIT;
2881:
2882: BEGIN
2883:

Line 2886: igf_sl_lor_loc_pkg.update_row (

2882: BEGIN
2883:
2884: FOR lorloc_rec in c_tbh_lor_rec LOOP
2885: gv_debug_str := gv_debug_str || 'UPDATE_LOR-15' ||' ';
2886: igf_sl_lor_loc_pkg.update_row (
2887: X_Mode => 'R' ,
2888: x_rowid => lorloc_rec.row_id ,
2889: x_loan_id => lorloc_rec.loan_id ,
2890: x_origination_id => lorloc_rec.origination_id ,