APPS.IGF_SL_DL_PRINT_PNOTE dependencies on IGF_SL_LOR_V

Line 98: CURSOR c_dl_orig_recs( x_ci_cal_type igf_sl_lor_v.ci_cal_type%TYPE,

94: SELECT igf_sl_lor.*
95: FROM igf_sl_lor
96: WHERE loan_id = x_loan_id FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
97:
98: CURSOR c_dl_orig_recs( x_ci_cal_type igf_sl_lor_v.ci_cal_type%TYPE,
99: x_ci_sequence_number igf_sl_lor_v.ci_sequence_number%TYPE,
100: x_loan_number igf_sl_lor_v.loan_number%TYPE,
101: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
102: x_pnote_status igf_sl_lor_v.pnote_status%TYPE,

Line 99: x_ci_sequence_number igf_sl_lor_v.ci_sequence_number%TYPE,

95: FROM igf_sl_lor
96: WHERE loan_id = x_loan_id FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
97:
98: CURSOR c_dl_orig_recs( x_ci_cal_type igf_sl_lor_v.ci_cal_type%TYPE,
99: x_ci_sequence_number igf_sl_lor_v.ci_sequence_number%TYPE,
100: x_loan_number igf_sl_lor_v.loan_number%TYPE,
101: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
102: x_pnote_status igf_sl_lor_v.pnote_status%TYPE,
103: x_lookup_type igf_lookups_view.lookup_type%TYPE

Line 100: x_loan_number igf_sl_lor_v.loan_number%TYPE,

96: WHERE loan_id = x_loan_id FOR UPDATE OF igf_sl_lor.pnote_status NOWAIT;
97:
98: CURSOR c_dl_orig_recs( x_ci_cal_type igf_sl_lor_v.ci_cal_type%TYPE,
99: x_ci_sequence_number igf_sl_lor_v.ci_sequence_number%TYPE,
100: x_loan_number igf_sl_lor_v.loan_number%TYPE,
101: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
102: x_pnote_status igf_sl_lor_v.pnote_status%TYPE,
103: x_lookup_type igf_lookups_view.lookup_type%TYPE
104: ) IS

Line 102: x_pnote_status igf_sl_lor_v.pnote_status%TYPE,

98: CURSOR c_dl_orig_recs( x_ci_cal_type igf_sl_lor_v.ci_cal_type%TYPE,
99: x_ci_sequence_number igf_sl_lor_v.ci_sequence_number%TYPE,
100: x_loan_number igf_sl_lor_v.loan_number%TYPE,
101: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
102: x_pnote_status igf_sl_lor_v.pnote_status%TYPE,
103: x_lookup_type igf_lookups_view.lookup_type%TYPE
104: ) IS
105: SELECT lor.loan_id
106: FROM igf_sl_lor_v lor, igf_ap_fa_base_rec fa

Line 106: FROM igf_sl_lor_v lor, igf_ap_fa_base_rec fa

102: x_pnote_status igf_sl_lor_v.pnote_status%TYPE,
103: x_lookup_type igf_lookups_view.lookup_type%TYPE
104: ) IS
105: SELECT lor.loan_id
106: FROM igf_sl_lor_v lor, igf_ap_fa_base_rec fa
107: WHERE lor.pnote_status = x_pnote_status AND
108: lor.student_id = fa.person_id AND
109: fa.base_id = NVL(x_base_id,fa.base_id) AND
110: lor.fed_fund_code IN ( SELECT DISTINCT lookup_code

Line 175: FROM igf_sl_lor_v

171:
172: --Get the Student Person,Parent Person and Loan Number for the current Loan ID
173: CURSOR cur_get_loans(p_ln_id igf_sl_loans_all.loan_id%TYPE) IS
174: SELECT student_id,p_person_id,loan_number
175: FROM igf_sl_lor_v
176: WHERE loan_id=p_ln_id;
177:
178: l_loan_rec cur_get_loans%ROWTYPE;
179: l_loan_rec_det cur_get_loans%ROWTYPE;

Line 206: l_pnote_status igf_sl_lor_v.pnote_status%TYPE;

202: r_stafford_det c_stafford_det%ROWTYPE;
203: r_plus_det c_plus_det%ROWTYPE;
204:
205: l_lookup_type igf_lookups_view.lookup_type%TYPE;
206: l_pnote_status igf_sl_lor_v.pnote_status%TYPE;
207:
208: l_current_per_num igf_aw_award_v.person_number%TYPE;
209:
210: SKIP_LOAN_RECORD EXCEPTION;