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.GMS_COST_PLUS_EXTN dependencies on GMS_ALLOWABLE_EXPENDITURES

Line 540: FROM gms_allowable_expenditures gae,

536: l_ap_brc NUMBER ;
537:
538: CURSOR get_burden_cost_limit is
539: SELECT gae.burden_cost_limit
540: FROM gms_allowable_expenditures gae,
541: gms_awards ga
542: where gae.allowability_schedule_id = ga.allowable_schedule_id
543: and gae.expenditure_type = P_EXP_TYPE
544: and ga.award_id = P_award_id;

Line 3254: gms_allowable_expenditures gae

3250: Cursor c_awd_exp is
3251: select distinct gbp.award_id,gbp.expenditure_type
3252: from gms_bc_packets gbp,
3253: gms_awards_all ga,
3254: gms_allowable_expenditures gae
3255: where gbp.packet_id = p_packet_id
3256: and ga.award_id = gbp.award_id
3257: and gae.allowability_schedule_id = ga.allowable_schedule_id
3258: and gae.expenditure_type = gbp.expenditure_type

Line 3739: from gms_allowable_expenditures gae,

3735: )
3736: )
3737: )
3738: )
3739: from gms_allowable_expenditures gae,
3740: gms_awards_all ga
3741: where ga.award_id = gbc.award_id
3742: and gae.allowability_schedule_id = ga.allowable_schedule_id
3743: and gae.expenditure_type = gbc.expenditure_type

Line 3893: gms_allowable_expenditures gae

3889: cursor C_award_exp is
3890: select distinct bcp.award_id, bcp.expenditure_type
3891: from gms_bc_packets bcp,
3892: gms_awards_all ga,
3893: gms_allowable_expenditures gae
3894: where bcp.packet_id = x_packet_id
3895: and status_code IN ('P','I') -- fix for bug : 2927485 ,to reject the transactions that may have already failed a setup step
3896: and bcp.burdenable_raw_cost is NULL
3897: and ga.award_id = bcp.award_id