APPS.IGF_SL_DL_PRINT_PNOTE dependencies on IGF_SL_DL_SETUP_V

Line 90: FROM igf_sl_dl_setup_v

86:
87: CURSOR c_pnote_check( x_ci_cal_type igf_sl_dl_setup.ci_cal_type%TYPE,
88: x_ci_sequence_number igf_sl_dl_setup.ci_sequence_number%TYPE ) IS
89: SELECT pnote_print_ind, ci_alternate_code
90: FROM igf_sl_dl_setup_v
91: WHERE ci_cal_type = x_ci_cal_type AND ci_sequence_number = x_ci_sequence_number;
92:
93: CURSOR c_lor_rec( x_loan_id igf_sl_lor.loan_id%TYPE ) IS
94: SELECT igf_sl_lor.*

Line 181: l_ci_cal_type igf_sl_dl_setup_v.ci_cal_type%TYPE;

177:
178: l_loan_rec cur_get_loans%ROWTYPE;
179: l_loan_rec_det cur_get_loans%ROWTYPE;
180:
181: l_ci_cal_type igf_sl_dl_setup_v.ci_cal_type%TYPE;
182: l_ci_sequence_number igf_sl_dl_setup_v.ci_sequence_number%TYPE;
183: l_alternate_code igs_ca_inst.alternate_code%TYPE;
184: l_batch_seq_num NUMBER(15);
185: l_no_of_pnotes NUMBER;

Line 182: l_ci_sequence_number igf_sl_dl_setup_v.ci_sequence_number%TYPE;

178: l_loan_rec cur_get_loans%ROWTYPE;
179: l_loan_rec_det cur_get_loans%ROWTYPE;
180:
181: l_ci_cal_type igf_sl_dl_setup_v.ci_cal_type%TYPE;
182: l_ci_sequence_number igf_sl_dl_setup_v.ci_sequence_number%TYPE;
183: l_alternate_code igs_ca_inst.alternate_code%TYPE;
184: l_batch_seq_num NUMBER(15);
185: l_no_of_pnotes NUMBER;
186: l_person_phone igf_sl_dl_pnote_p_p.s_phone%TYPE;