APPS.IGF_SL_LAR_CREATION dependencies on IGF_SL_ALT_BORW

Line 245: CURSOR alt_borw_cur (cp_loan_id igf_sl_alt_borw_all.loan_id%TYPE) IS

241: bvisvana 07-Oct-2005 Bug # 4636920 - Cosigner details not fetched properly.
242: CS1 Student Relationship and CS1 US Citizenship status are populated correctly.
243: */
244:
245: CURSOR alt_borw_cur (cp_loan_id igf_sl_alt_borw_all.loan_id%TYPE) IS
246: SELECT
247: alt.rowid row_id,
248: alt.*
249: FROM

Line 250: igf_sl_alt_borw_all alt

246: SELECT
247: alt.rowid row_id,
248: alt.*
249: FROM
250: igf_sl_alt_borw_all alt
251: WHERE
252: alt.loan_id = cp_loan_id;
253:
254: --Bug# 5006583 - bvisvana

Line 257: CURSOR cal_type_cur (cp_loan_id igf_sl_alt_borw_all.loan_id%TYPE) IS

253:
254: --Bug# 5006583 - bvisvana
255: -- get cal type and sequence number
256:
257: CURSOR cal_type_cur (cp_loan_id igf_sl_alt_borw_all.loan_id%TYPE) IS
258: SELECT
259: slor.ci_cal_type, slor.ci_sequence_number
260: FROM igf_sl_lor_v slor
261: WHERE slor.loan_id = cp_loan_id;

Line 296: l_albw_id igf_sl_alt_borw.albw_id%TYPE;

292: rel_code VARCHAR2(30);
293:
294: l_alt_borw_rec alt_borw_cur%ROWTYPE;
295: lv_rowid ROWID;
296: l_albw_id igf_sl_alt_borw.albw_id%TYPE;
297: cosigner_dtl_cur igf_sl_gen.person_dtl_cur;
298: cosigner_dtl_rec igf_sl_gen.person_dtl_rec;
299: l_person_phone VARCHAR2(30);
300:

Line 349: igf_sl_alt_borw_pkg.add_row (

345: END IF;
346:
347: cosigner_dtl_rec.p_permt_zip := TRANSLATE (UPPER(LTRIM(RTRIM(cosigner_dtl_rec.p_permt_zip))),'1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ`~!@#$%^&*_+=-,./?><():; ','1234567890');
348:
349: igf_sl_alt_borw_pkg.add_row (
350: x_rowid => l_alt_borw_rec.row_id ,
351: x_albw_id => l_alt_borw_rec.albw_id ,
352: x_loan_id => p_loan_id ,
353: x_fed_stafford_loan_debt => l_alt_borw_rec.fed_stafford_loan_debt ,