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_AW_GEN_003 dependencies on IGF_AW_FUND_MAST_ALL

Line 3144: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

3140:
3141:
3142: FUNCTION check_amounts ( p_calling_form IN OUT NOCOPY VARCHAR2,
3143: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
3144: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
3145: p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE,
3146: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
3147: p_person_number IN igf_aw_award_v.person_number%TYPE,
3148: p_award_id IN igf_aw_award_all.award_id%TYPE,

Line 3145: p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE,

3141:
3142: FUNCTION check_amounts ( p_calling_form IN OUT NOCOPY VARCHAR2,
3143: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
3144: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
3145: p_fund_code IN igf_aw_fund_mast_all.fund_code%TYPE,
3146: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
3147: p_person_number IN igf_aw_award_v.person_number%TYPE,
3148: p_award_id IN igf_aw_award_all.award_id%TYPE,
3149: p_act_isir IN VARCHAR2,

Line 3198: CURSOR cur_max_lf_count ( cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE ,

3194: --
3195: -- Gets the max amt + max terms the student got a fund in a lifetime
3196: --
3197:
3198: CURSOR cur_max_lf_count ( cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE ,
3199: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
3200: IS
3201: SELECT
3202: NVL(SUM(NVL(disb.disb_gross_amt,0)),0) lf_total,

Line 3207: igf_aw_fund_mast_all fmast,

3203: COUNT(DISTINCT awd.award_id) lf_count
3204: FROM
3205: igf_aw_awd_disb_all disb,
3206: igf_aw_award_all awd,
3207: igf_aw_fund_mast_all fmast,
3208: igf_ap_fa_base_rec_all fabase
3209: WHERE fmast.fund_code = cp_fund_code
3210: AND disb.award_id = awd.award_id
3211: AND awd.fund_id = fmast.fund_id

Line 3222: CURSOR cur_agg_lf_count ( cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE ,

3218:
3219: --
3220: -- Cursor to Aggregate Award and Count
3221: --
3222: CURSOR cur_agg_lf_count ( cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE ,
3223: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
3224: IS
3225: SELECT NVL(SUM(NVL(awd.offered_amt,0)),0) lf_total,
3226: COUNT(awd.award_id) lf_count

Line 3228: igf_aw_fund_mast_all fmast,

3224: IS
3225: SELECT NVL(SUM(NVL(awd.offered_amt,0)),0) lf_total,
3226: COUNT(awd.award_id) lf_count
3227: FROM igf_aw_award_all awd,
3228: igf_aw_fund_mast_all fmast,
3229: igf_ap_fa_base_rec fabase,
3230: igf_ap_batch_aw_map_all bam
3231: WHERE fmast.fund_code = cp_fund_code
3232: AND awd.fund_id = fmast.fund_id

Line 3246: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)

3242: -- This cursor retrives Total Award for a Fund - This is Yearly amount
3243: --
3244:
3245: CURSOR cur_total_fund_awd (p_base_id igf_aw_award.base_id%TYPE,
3246: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
3247: IS
3248: SELECT SUM(disb.disb_gross_amt) total_fund_amt
3249: FROM
3250: igf_aw_award awd,

Line 3277: CURSOR cur_chk_fdl_fund (p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)

3273:
3274: --
3275: -- Cursor to determine if the Fund uses federal methodology or not
3276: --
3277: CURSOR cur_chk_fdl_fund (p_fund_id igf_aw_fund_mast_all.fund_id%TYPE)
3278: IS
3279: SELECT
3280: fm.replace_fc
3281: FROM

Line 3311: igf_aw_fund_mast_all fmast

3307: fmast.min_award_amt,
3308: fmast.max_num_disb,
3309: fmast.min_num_disb
3310: FROM
3311: igf_aw_fund_mast_all fmast
3312: WHERE
3313: fmast.fund_id = p_fund_id;
3314:
3315: fund_details_rec cur_fund_details%ROWTYPE;

Line 3878: p_new_val IN igf_aw_fund_mast_all.show_on_bill%TYPE)

3874: --
3875: -- Procedure to update show_on_bill flag based on the fund manager value
3876: --
3877: PROCEDURE update_bill_flag ( p_fund_id IN igf_aw_award_all.fund_id%TYPE,
3878: p_new_val IN igf_aw_fund_mast_all.show_on_bill%TYPE)
3879: IS
3880:
3881: --
3882: -- Cursor to get awards of the fund

Line 3897: p_new_val IN igf_aw_fund_mast_all.show_on_bill%TYPE)

3893: --
3894: -- Cursor to get Planned Disbursements for the award
3895: --
3896: CURSOR cur_get_adisb ( p_award_id IN igf_aw_award_all.award_id%TYPE,
3897: p_new_val IN igf_aw_fund_mast_all.show_on_bill%TYPE)
3898: IS
3899: SELECT *
3900: FROM
3901: igf_aw_awd_disb