APPS.IGF_SL_DL_RECORD dependencies on IGF_SL_LOR

Line 454: instead of using igf_sl_lor_dtls_v used simple

450:
451:
452: bkkumar 30-sep-2003 Bug 3104228 FA 122 Loans Enhancements
453: Added the cursor c_lor_details and
454: instead of using igf_sl_lor_dtls_v used simple
455: joins and got the details of student and parent
456: from igf_sl_gen.get_person_details.
457: Added the debugging log messages.
458: smvk 17-Feb-2003 Bug # 2758823. Added filler space from 132 to 153 for dl_version 2003-2004 for ED to use.

Line 484: -- cursor to replace the columns selected from the igf_sl_lor_dtls_v FA 122 Enhancements

480: parent_dtl_cur igf_sl_gen.person_dtl_cur;
481: student_dtl_rec igf_sl_gen.person_dtl_rec;
482: parent_dtl_rec igf_sl_gen.person_dtl_rec;
483:
484: -- cursor to replace the columns selected from the igf_sl_lor_dtls_v FA 122 Enhancements
485:
486: CURSOR c_lor_details (
487: cp_cal_type igs_ca_inst.cal_type%TYPE,
488: cp_seq_number igs_ca_inst.sequence_number%TYPE,

Line 524: igf_sl_lor lor,

520: isr.citizenship_status,
521: isr.dependency_status
522: FROM
523: igf_sl_loans loans,
524: igf_sl_lor lor,
525: igf_aw_award awd,
526: igf_aw_fund_mast fmast,
527: igf_aw_fund_cat fcat,
528: igf_ap_fa_base_rec fabase,