APPS.GMS_COST_PLUS_EXTN dependencies on GMS_AWARDS

Line 541: gms_awards ga

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;
545: --

Line 1134: FROM gms_awards_all -- bug 3117503. changed to _all.

1130: SELECT idc_schedule_id,
1131: cost_ind_sch_fixed_date
1132: INTO l_rate_sch_id,
1133: l_sch_fixed_date
1134: FROM gms_awards_all -- bug 3117503. changed to _all.
1135: WHERE award_id = x_award_id;
1136: END IF; -- Bug 2097676: Multiple IDC Build
1137:
1138: IF l_rate_sch_id is not null THEN

Line 3253: gms_awards_all ga,

3249: -- * Only check original transaction being FC'ed (parent_bc_packet_id is null)
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

Line 3740: gms_awards_all ga

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
3744: )

Line 3892: gms_awards_all ga,

3888:
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