[Home] [Help]
330: TRUNC(fabase.coa_f) coa_f,
331: loans.external_loan_id_txt
332: FROM igf_sl_loans loans,
333: igf_sl_lor lor,
334: igf_aw_award awd,
335: igf_aw_fund_mast fmast,
336: igf_aw_fund_cat fcat,
337: igf_ap_fa_base_rec fabase,
338: igf_sl_cl_recipient recip
393: -- This cursor is modified to fetch only one attribute eft_authorization.
394: -- School Id is now available as passed in parameter p_school_id.
395: -- Non Ed Branch is not used.
396:
397: CURSOR c_nof_awd_disb (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
398: SELECT COUNT(awd.disb_num) tot_disb
399: FROM igf_aw_awd_disb_all awd
400: WHERE awd.award_id = cp_n_award_id
401: GROUP BY awd.award_id
478: 0
479: )),
480: 0) resource_fm_f
481: FROM igf_aw_awd_disb_all disb,
482: igf_aw_award_all awd,
483: igf_aw_fund_mast_all fm,
484: (SELECT base_id,
485: ld_cal_type,
486: ld_sequence_number
594:
595: PROCEDURE loan_limit_validation (
596: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
597: p_fund_type IN igf_aw_fund_cat.fed_fund_code%TYPE,
598: p_award_id IN igf_aw_award_all.award_id%TYPE,
599: p_msg_name OUT NOCOPY fnd_new_messages.message_name%TYPE
600: )
601: IS
602: /***************************************************************
609: bvisvana 10-Apr-2006 Removed the check for defalut status of parent and student as part of Bug # 4127532
610: ***************************************************************/
611: l_aid NUMBER;
612:
613: CURSOR c_get_dist_plan(cp_award_id igf_aw_award_all.award_id%TYPE)
614: IS
615: SELECT adplans_id
616: FROM igf_aw_award_all
617: WHERE award_id = cp_award_id;
612:
613: CURSOR c_get_dist_plan(cp_award_id igf_aw_award_all.award_id%TYPE)
614: IS
615: SELECT adplans_id
616: FROM igf_aw_award_all
617: WHERE award_id = cp_award_id;
618:
619: l_dist_plan_rec c_get_dist_plan%ROWTYPE;
620: