APPS.IGF_SL_CL_LI_IMP_PKG dependencies on IGF_SL_ALT_BORW_ALL

Line 3346: FROM igf_sl_alt_borw_all

3342:
3343: CURSOR c_alt_borw(cp_loan_id NUMBER)
3344: IS
3345: SELECT rowid
3346: FROM igf_sl_alt_borw_all
3347: WHERE loan_id = cp_loan_id;
3348:
3349: l_alt_borw c_alt_borw%ROWTYPE;
3350:

Line 3608: ln_albw_id igf_sl_alt_borw_all.albw_id%TYPE;

3604: l_b_license_state VARCHAR2(30);
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)

Line 3945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_ALT_BORW_ALL');

3941:
3942: IF p_fed_fund = 'ALT' THEN
3943:
3944: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','Before insert into IGF_SL_ALT_BORW_ALL');
3946: END IF;
3947:
3948: ln_albw_id := NULL;
3949: alt_rowid := NULL;

Line 4036: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_ALT_BORW_ALL albw_id ' || ln_albw_id);

4032: x_cs2_years_at_address_txt => p_interface.cs2_years_at_address_txt
4033: );
4034:
4035: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4036: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After insert into IGF_SL_ALT_BORW_ALL albw_id ' || ln_albw_id);
4037: END IF;
4038:
4039: END IF;
4040: