APPS.IGF_SL_DL_PNOTE_ACK dependencies on IGF_SL_LOANS_V

Line 494: FROM igf_sl_loans_v loans

490: -- To Check whether the Loan Exists in Financial Aid i.e exists in
491:
492: CURSOR cur_loans(p_loan_number igf_sl_dl_pnote_resp_all.loan_number%TYPE) IS
493: SELECT fed_fund_code, count(*) countcol
494: FROM igf_sl_loans_v loans
495: WHERE loan_number=p_loan_number
496: GROUP BY fed_fund_code;
497:
498: -- TO get loan_id from the particular loan_number

Line 804: igf_sl_loans_v WHERE

800:
801: DECLARE
802: CURSOR cur_award(p_loan_number igf_sl_dl_pnote_resp_all.loan_number%TYPE) IS
803: SELECT NVL(loan_amt_offered,loan_amt_accepted) loan_amt FROM
804: igf_sl_loans_v WHERE
805: loan_number = TRIM(p_loan_number);
806:
807: lcur_award cur_award%ROWTYPE;
808: BEGIN