eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_CL_VALIDATION dependencies on IGF_AW_AWD_DISB

Line 370: FROM igf_aw_awd_disb awdb

366:
367: CURSOR cur_count_disb_amount
368: IS
369: SELECT COUNT(award_id)
370: FROM igf_aw_awd_disb awdb
371: WHERE award_id = lor_rec_temp.award_id
372: AND disb_accepted_amt <= 0;
373:
374: -- Cursor to find whether any of the disbursment indicators is NULL

Line 378: FROM igf_aw_awd_disb awdb

374: -- Cursor to find whether any of the disbursment indicators is NULL
375:
376: CURSOR cur_count_disb_ind IS
377: SELECT COUNT(award_id)
378: FROM igf_aw_awd_disb awdb
379: WHERE award_id=lor_rec_temp.award_id
380: AND hold_rel_ind IS NULL;
381:
382: -- Cursor to find whether any of the disbursment dates is NULL

Line 386: FROM igf_aw_awd_disb awdb

382: -- Cursor to find whether any of the disbursment dates is NULL
383:
384: CURSOR cur_count_disb_dates IS
385: SELECT COUNT(award_id)
386: FROM igf_aw_awd_disb awdb
387: WHERE award_id=lor_rec_temp.award_id
388: AND disb_date IS NULL;
389:
390:

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,