APPS.IGF_SL_CL_VALIDATION dependencies on IGF_AW_AWD_DISB_ALL

Line 399: FROM igf_aw_awd_disb_all awd

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
402: HAVING COUNT(awd.disb_num) > 4;
403:

Line 481: FROM igf_aw_awd_disb_all disb,

477: 'Y', NVL (disb.disb_gross_amt, 0),
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,