APPS.IGF_SL_DL_PRINT_PNOTE dependencies on IGF_AP_FA_BASE_REC

Line 58: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

54: ERRBUF OUT NOCOPY VARCHAR2,
55: RETCODE OUT NOCOPY NUMBER,
56: p_award_year IN VARCHAR2,
57: p_loan_catg IN igf_lookups_view.lookup_code%TYPE,
58: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
59: p_loan_number IN igf_sl_loans_v.loan_number%TYPE,
60: p_org_id IN NUMBER
61: )AS
62: /***************************************************************

Line 101: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

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
105: SELECT lor.loan_id

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 131: igf_ap_fa_base_rec fa,

127: prsn.middle_name,
128: prsn.birth_dt
129: FROM igf_sl_loans loans,
130: igf_aw_award awd,
131: igf_ap_fa_base_rec fa,
132: igf_ap_person_v prsn
133: WHERE loans.loan_id = x_loan_id
134: AND loans.award_id = awd.award_id
135: AND awd.base_id = fa.base_id

Line 161: igf_ap_fa_base_rec fa,

157: parent.birth_dt p_date_of_birth
158: FROM igf_sl_lor lor,
159: igf_sl_loans loans,
160: igf_aw_award awd,
161: igf_ap_fa_base_rec fa,
162: igf_ap_person_v prsn,
163: igs_pe_person_v parent
164: WHERE lor.loan_id = x_loan_id
165: AND lor.loan_id = loans.loan_id

Line 213: PROCEDURE log_message(p_stud_id igf_ap_fa_base_rec_all.person_id%TYPE,p_ln_number igf_sl_loans_all.loan_number%TYPE) IS

209:
210: SKIP_LOAN_RECORD EXCEPTION;
211:
212: --Internal Procedure to display LOG Message
213: PROCEDURE log_message(p_stud_id igf_ap_fa_base_rec_all.person_id%TYPE,p_ln_number igf_sl_loans_all.loan_number%TYPE) IS
214: /***************************************************************
215: Created By : mesriniv
216: Date Created By : 2002/06/25
217: Purpose :