APPS.IGF_SL_CL_CHG_FILE dependencies on IGF_SL_LENDER

Line 1570: FROM igf_sl_lender

1566:
1567: CURSOR c_sl_lender (cp_n_recipient_id IN igf_sl_cl_recipient.recipient_id%TYPE) IS
1568: SELECT lender_id
1569: ,description
1570: FROM igf_sl_lender
1571: WHERE lender_id = cp_n_recipient_id
1572: AND enabled = 'Y';
1573:
1574: CURSOR c_sl_guarantor (cp_n_recipient_id IN igf_sl_cl_recipient.recipient_id%TYPE) IS

Line 1670: l_n_lender_id igf_sl_lender.lender_id%TYPE;

1666: l_n_recipient_id igf_sl_cl_recipient.recipient_id%TYPE;
1667: l_v_recipient_name igf_sl_servicer.description%TYPE;
1668: l_v_recipient_type igf_sl_cl_recipient.recipient_type%TYPE;
1669: l_v_recip_non_edbrc_id igf_sl_cl_recipient.recip_non_ed_brc_id%TYPE;
1670: l_n_lender_id igf_sl_lender.lender_id%TYPE;
1671: l_n_guarantor_id igf_sl_guarantor.guarantor_id%TYPE;
1672: l_n_servicer_id igf_sl_servicer.servicer_id%TYPE;
1673: l_v_filler_2_char VARCHAR2(2);
1674: l_v_batch_id igf_sl_cl_batch.batch_id%TYPE;