APPS.IGF_SL_LAR_CREATION dependencies on IGF_SL_ALT_BORW_ALL

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;