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.

[Home] [Help]

APPS.IGF_GR_GEN_XML dependencies on IGF_AW_AWD_DISB

Line 1171: CURSOR cur_get_num_of_disb (cp_award_id igf_aw_awd_disb.award_id%TYPE) IS

1167: AND b.disb_num = a.disb_num);
1168: rec_disb_amt_tot cur_disb_amt_tot%ROWTYPE;
1169:
1170: -- To get number of disbursements with disbursement release indicator 'true'
1171: CURSOR cur_get_num_of_disb (cp_award_id igf_aw_awd_disb.award_id%TYPE) IS
1172: SELECT count(*)
1173: FROM IGF_AW_AWD_DISB disb
1174: WHERE disb.award_id = cp_award_id
1175: AND UPPER(disb.hold_rel_ind) = 'TRUE';

Line 1173: FROM IGF_AW_AWD_DISB disb

1169:
1170: -- To get number of disbursements with disbursement release indicator 'true'
1171: CURSOR cur_get_num_of_disb (cp_award_id igf_aw_awd_disb.award_id%TYPE) IS
1172: SELECT count(*)
1173: FROM IGF_AW_AWD_DISB disb
1174: WHERE disb.award_id = cp_award_id
1175: AND UPPER(disb.hold_rel_ind) = 'TRUE';
1176: ln_num_disb_with_relflag_true NUMBER(3);
1177: