2342: AS
2343: /*
2344: || Created By : rasahoo
2345: || Created On : 03-June-2003
2346: || Purpose : Inserts legacy data into igf_sl_dl_pnote_p_p_all Table .
2347: || Change History :
2348: || Who When What
2349: || veramach 16-SEP-2003 FA 122 loan enhancements
2350: || 1. c_loan_dtls does not select borrower information from igf_sl_lor_dtls_v
2848:
2849: CURSOR c_pnote(cp_loan_id NUMBER)
2850: IS
2851: SELECT ROWID
2852: FROM igf_sl_dl_pnote_p_p_all
2853: WHERE loan_id = cp_loan_id;
2854:
2855: l_pnote c_pnote%ROWTYPE;
2856: