APPS.IGF_SL_CL_CHG_FILE dependencies on IGF_SL_GUARANTOR

Line 1577: FROM igf_sl_guarantor

1573:
1574: CURSOR c_sl_guarantor (cp_n_recipient_id IN igf_sl_cl_recipient.recipient_id%TYPE) IS
1575: SELECT guarantor_id
1576: ,description
1577: FROM igf_sl_guarantor
1578: WHERE guarantor_id = cp_n_recipient_id
1579: AND enabled = 'Y';
1580:
1581:

Line 1671: l_n_guarantor_id igf_sl_guarantor.guarantor_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;
1675: l_v_rowid ROWID;