APPS.IGF_SL_CL_ORIG_ACK dependencies on IGF_SL_LOR_ALL

Line 62: -- in igf_sl_lor_all table and obsoleting

58: -- always runs for one specific school.
59: --
60: -- bkkumar 08-oct-2003 Bug 3104228
61: -- a) Impact of adding the relationship_cd
62: -- in igf_sl_lor_all table and obsoleting
63: -- BORW_LENDER_ID, DUNS_BORW_LENDER_ID,
64: -- GUARANTOR_ID, DUNS_GUARNT_ID,
65: -- LENDER_ID, DUNS_LENDER_ID
66: -- LEND_NON_ED_BRC_ID, RECIPIENT_ID

Line 593: FROM igf_sl_lor_all lor,

589: rec_c_loan c_loan%ROWTYPE;
590:
591: CURSOR c_igf_sl_lor (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
592: SELECT lor.rec_type_ind
593: FROM igf_sl_lor_all lor,
594: igf_sl_loans_all loan
595: WHERE loan.loan_id = lor.loan_id AND
596: NVL(loan.external_loan_id_txt,loan.loan_number) = cp_v_loan_number;
597:

Line 642: l_v_rec_type_ind igf_sl_lor_all.rec_type_ind%TYPE;

638:
639: l_v_cl_file_type igf_sl_cl_file_type.cl_file_type%TYPE;
640: e_skip EXCEPTION;
641: rec_scr_sl_resp igf_sl_cl_resp_r1_all%ROWTYPE;
642: l_v_rec_type_ind igf_sl_lor_all.rec_type_ind%TYPE;
643: l_n_award_id igf_aw_award_all.award_id%TYPE;
644: l_n_resp_guarantee_amt igf_sl_cl_resp_r1_all.guarantee_amt%TYPE;
645: l_n_resp_fls_approved_amt igf_sl_cl_resp_r1_all.fls_approved_amt%TYPE;
646: l_n_resp_flu_approved_amt igf_sl_cl_resp_r1_all.flu_approved_amt%TYPE;

Line 2255: in igf_sl_lor_all table and obsoleting

2251:
2252: bkkumar 02-04-04 FACR116 - The lender related comparison not required when "ALT" Loan
2253: bkkumar 08-oct-2003 Bug 3104228
2254: a) Impact of adding the relationship_cd
2255: in igf_sl_lor_all table and obsoleting
2256: BORW_LENDER_ID, DUNS_BORW_LENDER_ID,
2257: GUARANTOR_ID, DUNS_GUARNT_ID,
2258: LENDER_ID, DUNS_LENDER_ID
2259: LEND_NON_ED_BRC_ID, RECIPIENT_ID