APPS.IGF_DB_DL_DISB_ORIG dependencies on IGF_AW_AWARD_ALL

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 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: