APPS.IGF_SL_CL_ORIG dependencies on IGF_SL_ALT_BORW

Line 1274: l_tot_alt_debt igf_sl_alt_borw.fed_sls_debt%TYPE;

1270: lv_p_foreign_postal_code igf_sl_lor_loc.p_foreign_postal_code%TYPE;
1271: l_est_fin igf_aw_award_all.accepted_amt%TYPE;
1272: l_plus_cert_amt igf_aw_award_all.accepted_amt%TYPE;
1273: l_alt_cert_amt igf_aw_award_all.accepted_amt%TYPE;
1274: l_tot_alt_debt igf_sl_alt_borw.fed_sls_debt%TYPE;
1275: alter_rec igf_sl_alt_borw%ROWTYPE;
1276:
1277: l_count_4 NUMBER;
1278: lv_header_rec VARCHAR2(1000);

Line 1275: alter_rec igf_sl_alt_borw%ROWTYPE;

1271: l_est_fin igf_aw_award_all.accepted_amt%TYPE;
1272: l_plus_cert_amt igf_aw_award_all.accepted_amt%TYPE;
1273: l_alt_cert_amt igf_aw_award_all.accepted_amt%TYPE;
1274: l_tot_alt_debt igf_sl_alt_borw.fed_sls_debt%TYPE;
1275: alter_rec igf_sl_alt_borw%ROWTYPE;
1276:
1277: l_count_4 NUMBER;
1278: lv_header_rec VARCHAR2(1000);
1279: lv_trailer_rec VARCHAR2(1000);

Line 1404: FROM igf_sl_alt_borw,

1400: IS
1401: SELECT LPAD(SUM(NVL(fed_stafford_loan_debt,0) + NVL(fed_sls_debt,0) +
1402: NVL(heal_debt,0) + NVL(perkins_debt,0) +
1403: NVL(other_debt,0)),7,0) alt_loan_debt
1404: FROM igf_sl_alt_borw,
1405: igf_sl_loans_v loanv
1406: WHERE igf_sl_alt_borw.loan_id = loanv.loan_id
1407: AND loanv.student_id = loan_rec.student_id
1408: AND loanv.ci_cal_type <> loan_rec.ci_cal_type

Line 1406: WHERE igf_sl_alt_borw.loan_id = loanv.loan_id

1402: NVL(heal_debt,0) + NVL(perkins_debt,0) +
1403: NVL(other_debt,0)),7,0) alt_loan_debt
1404: FROM igf_sl_alt_borw,
1405: igf_sl_loans_v loanv
1406: WHERE igf_sl_alt_borw.loan_id = loanv.loan_id
1407: AND loanv.student_id = loan_rec.student_id
1408: AND loanv.ci_cal_type <> loan_rec.ci_cal_type
1409: AND loanv.ci_sequence_number <> loan_rec.ci_sequence_number;
1410:

Line 1416: FROM igf_sl_alt_borw alt

1412: -- Cursor to fetch the Alternate Borrower Details if any for the Loan ID
1413: CURSOR cur_get_alternate
1414: IS
1415: SELECT alt.*
1416: FROM igf_sl_alt_borw alt
1417: WHERE loan_id=loan_rec.loan_id;
1418:
1419: --
1420: -- Cursor to fetch number of disb recs for loan