APPS.IGF_SL_CL_ORIG_ACK dependencies on IGF_SL_ALT_BORW

Line 3993: l_fed_stafford igf_sl_alt_borw.fed_stafford_loan_debt%TYPE;

3989:
3990:
3991: l_rowid VARCHAR2(25) DEFAULT NULL;
3992: l_loan_id igf_sl_loans_all.loan_id%TYPE;
3993: l_fed_stafford igf_sl_alt_borw.fed_stafford_loan_debt%TYPE;
3994: l_fed_sls igf_sl_alt_borw.fed_sls_debt%TYPE;
3995: rec_cl_resp_r4 igf_sl_cl_resp_r4_all%ROWTYPE;
3996: BEGIN --for the procedure insert_into_resp_r4
3997:

Line 3994: l_fed_sls igf_sl_alt_borw.fed_sls_debt%TYPE;

3990:
3991: l_rowid VARCHAR2(25) DEFAULT NULL;
3992: l_loan_id igf_sl_loans_all.loan_id%TYPE;
3993: l_fed_stafford igf_sl_alt_borw.fed_stafford_loan_debt%TYPE;
3994: l_fed_sls igf_sl_alt_borw.fed_sls_debt%TYPE;
3995: rec_cl_resp_r4 igf_sl_cl_resp_r4_all%ROWTYPE;
3996: BEGIN --for the procedure insert_into_resp_r4
3997:
3998: gv_debug_str := 'INSERT_INTO_RESP_R4 - 1' || ' ';

Line 4182: FROM igf_sl_alt_borw borw

4178: --
4179: CURSOR cur_alt_borw
4180: IS
4181: SELECT borw.*
4182: FROM igf_sl_alt_borw borw
4183: WHERE loan_id=p_loan_id;
4184:
4185: --
4186: -- Cursor to Fetch the Alternate Borrower's Information loaded from File

Line 4199: ofa_rec igf_sl_alt_borw%ROWTYPE;

4195: -- Array declared here to store the difference in data.
4196: --
4197: TYPE tab_data_array IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
4198:
4199: ofa_rec igf_sl_alt_borw%ROWTYPE;
4200: file_rec igf_sl_cl_resp_r4%ROWTYPE;
4201:
4202: l_alt_title VARCHAR2(2000);
4203: l_alt_data VARCHAR2(2000);