[Home] [Help]
803: l_ap_brc NUMBER ;
804:
805: CURSOR get_burden_cost_limit is
806: SELECT gae.burden_cost_limit
807: FROM gms_allowable_expenditures gae,
808: gms_awards ga
809: where gae.allowability_schedule_id = ga.allowable_schedule_id
810: and gae.expenditure_type = P_EXP_TYPE
811: and ga.award_id = P_award_id;
3614: Cursor c_awd_exp is
3615: select distinct gbp.award_id,gbp.expenditure_type
3616: from gms_bc_packets gbp,
3617: gms_awards_all ga,
3618: gms_allowable_expenditures gae
3619: where gbp.packet_id = p_packet_id
3620: and ga.award_id = gbp.award_id
3621: and gae.allowability_schedule_id = ga.allowable_schedule_id
3622: and gae.expenditure_type = gbp.expenditure_type
4117: )
4118: )
4119: )
4120: )
4121: from gms_allowable_expenditures gae,
4122: gms_awards_all ga
4123: where ga.award_id = gbc.award_id
4124: and gae.allowability_schedule_id = ga.allowable_schedule_id
4125: and gae.expenditure_type = gbc.expenditure_type
4271: cursor C_award_exp is
4272: select distinct bcp.award_id, bcp.expenditure_type
4273: from gms_bc_packets bcp,
4274: gms_awards_all ga,
4275: gms_allowable_expenditures gae
4276: where bcp.packet_id = x_packet_id
4277: and status_code IN ('P','I') -- fix for bug : 2927485 ,to reject the transactions that may have already failed a setup step
4278: and bcp.burdenable_raw_cost is NULL
4279: and ga.award_id = bcp.award_id