APPS.IGF_SL_CL_CHG_FILE dependencies on IGF_SL_SERVICER

Line 1585: FROM igf_sl_servicer

1581:
1582: CURSOR c_sl_servicer (cp_n_recipient_id IN igf_sl_cl_recipient.recipient_id%TYPE) IS
1583: SELECT servicer_id
1584: ,description
1585: FROM igf_sl_servicer
1586: WHERE servicer_id = cp_n_recipient_id
1587: AND enabled = 'Y';
1588:
1589: CURSOR c_sl_clchsn_dtls (cp_v_loan_number IN igf_sl_loans_all.loan_number%TYPE) IS

Line 1667: l_v_recipient_name igf_sl_servicer.description%TYPE;

1663: l_v_file_crea_time VARCHAR2(6);
1664: l_v_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1665: l_v_source_name igf_ap_school_opeid_v.meaning%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;

Line 1672: l_n_servicer_id igf_sl_servicer.servicer_id%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;
1676: l_n_cbth_id igf_sl_cl_batch.cbth_id%TYPE;