APPS.IGF_SL_CL_LI_IMP_PKG dependencies on IGF_SL_LOR_ALL

Line 72: -- in igf_sl_lor_all table and obsoleting

68: -- LENDER_ID_TXT,LEND_NON_ED_BRC_ID_TXT,RECIPIENT_ID_TXT,
69: -- RECIPIENT_TYPE,RECIPIENT_NON_ED_BRC_ID_TXT from the
70: -- interface table and also adding a new column relationship_cd
71: -- b) Impact of adding the relationship_cd
72: -- in igf_sl_lor_all table and obsoleting
73: -- BORW_LENDER_ID, DUNS_BORW_LENDER_ID,
74: -- GUARANTOR_ID, DUNS_GUARNT_ID,
75: -- LENDER_ID, DUNS_LENDER_ID
76: -- LEND_NON_ED_BRC_ID, RECIPIENT_ID

Line 3330: FROM igf_sl_lor_all

3326: IS
3327: SELECT
3328: rowid,
3329: origination_id
3330: FROM igf_sl_lor_all
3331: WHERE loan_id = cp_loan_id;
3332:
3333: l_lor c_lor%ROWTYPE;
3334:

Line 3552: -- in igf_sl_lor_all table and obsoleting

3548: -- LENDER_ID_TXT,LEND_NON_ED_BRC_ID_TXT,RECIPIENT_ID_TXT,
3549: -- RECIPIENT_TYPE,RECIPIENT_NON_ED_BRC_ID_TXT from the
3550: -- interface table and also adding a new column relationship_cd
3551: -- b) Impact of adding the relationship_cd
3552: -- in igf_sl_lor_all table and obsoleting
3553: -- BORW_LENDER_ID, DUNS_BORW_LENDER_ID,
3554: -- GUARANTOR_ID, DUNS_GUARNT_ID,
3555: -- LENDER_ID, DUNS_LENDER_ID
3556: -- LEND_NON_ED_BRC_ID, RECIPIENT_ID

Line 3609: ln_origination_id igf_sl_lor_all.origination_id%TYPE;

3605: l_b_license_number VARCHAR2(30);
3606:
3607: ln_loan_id igf_sl_loans.loan_id%TYPE;
3608: ln_albw_id igf_sl_alt_borw_all.albw_id%TYPE;
3609: ln_origination_id igf_sl_lor_all.origination_id%TYPE;
3610:
3611: -- FA 122 Loans Enhancements
3612: CURSOR c_get_base_id ( cp_award_id igf_aw_award.award_id%TYPE)
3613: IS