DBA Data[Home] [Help]

APPS.IGF_SL_DL_RECORD dependencies on IGF_SL_LOANS_V

Line 335: cp_start_dt igf_sl_loans_v.loan_per_begin_date%TYPE ,

331:
332: -- cursor to get acad_cal for that loan_number
333: CURSOR get_acad_cal ( cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ,
334: cp_ver_num igs_ps_ofr_inst.version_number%TYPE ,
335: cp_start_dt igf_sl_loans_v.loan_per_begin_date%TYPE ,
336: cp_end_dt igf_sl_loans_v.loan_per_end_date%TYPE ) IS
337: SELECT cal_type, ci_sequence_number, ci_start_dt, ci_end_dt
338: FROM igs_ps_ofr_inst
339: WHERE course_cd = cp_course_cd

Line 336: cp_end_dt igf_sl_loans_v.loan_per_end_date%TYPE ) IS

332: -- cursor to get acad_cal for that loan_number
333: CURSOR get_acad_cal ( cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ,
334: cp_ver_num igs_ps_ofr_inst.version_number%TYPE ,
335: cp_start_dt igf_sl_loans_v.loan_per_begin_date%TYPE ,
336: cp_end_dt igf_sl_loans_v.loan_per_end_date%TYPE ) IS
337: SELECT cal_type, ci_sequence_number, ci_start_dt, ci_end_dt
338: FROM igs_ps_ofr_inst
339: WHERE course_cd = cp_course_cd
340: AND version_number = cp_ver_num