APPS.IGF_DB_DL_DISB_ORIG dependencies on IGF_AW_AWARD

Line 114: igf_aw_award awd,

110: CURSOR cur_disb_dtl(lv_ci_cal_type igs_ca_inst.cal_type%TYPE,
111: lv_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
112: SELECT '1'
113: FROM igf_aw_db_chg_dtls adtlv,
114: igf_aw_award awd,
115: igf_sl_loans lar,
116: igf_ap_fa_base_rec fabase
117: WHERE -- ## Pick up all records with SF Status 1)"to be Posted" and Pick up Disbursements with Future dates and within 7 Future days,
118: -- "Posted" to Student Account.

Line 349: igf_aw_award awd,

345:
346: CURSOR cur_disb_dtl IS
347: SELECT adtlv.*, fabase.base_id, lar.loan_number
348: FROM igf_aw_db_chg_dtls adtlv,
349: igf_aw_award awd,
350: igf_sl_loans lar,
351: igf_ap_fa_base_rec fabase
352: WHERE
353: adtlv.disb_date-TRUNC(SYSDATE) <=7

Line 372: CURSOR cur_fund_details(p_award_id igf_aw_award_all.award_id%TYPE) IS

368: WHERE ci_cal_type = p_ci_cal_type
369: AND ci_sequence_number = p_ci_sequence_number;
370:
371: -- Cursor to get the Fed Fund code for the specified award.
372: CURSOR cur_fund_details(p_award_id igf_aw_award_all.award_id%TYPE) IS
373: SELECT awd.fund_id, fcat.fed_fund_code
374: FROM igf_aw_fund_mast fmast,
375: igf_aw_fund_cat fcat,
376: igf_aw_award awd

Line 376: igf_aw_award awd

372: CURSOR cur_fund_details(p_award_id igf_aw_award_all.award_id%TYPE) IS
373: SELECT awd.fund_id, fcat.fed_fund_code
374: FROM igf_aw_fund_mast fmast,
375: igf_aw_fund_cat fcat,
376: igf_aw_award awd
377: WHERE awd.award_id = p_award_id
378: AND awd.fund_id = fmast.fund_id
379: AND fmast.fund_code = fcat.fund_code;
380:

Line 381: CURSOR cur_min_disb_num (cp_award_id igf_aw_award_all.award_id%TYPE) IS

377: WHERE awd.award_id = p_award_id
378: AND awd.fund_id = fmast.fund_id
379: AND fmast.fund_code = fcat.fund_code;
380:
381: CURSOR cur_min_disb_num (cp_award_id igf_aw_award_all.award_id%TYPE) IS
382: SELECT MIN(disb_num)
383: FROM igf_aw_awd_disb
384: WHERE award_id = cp_award_id;
385: