DBA Data[Home] [Help]

APPS.GMS_COST_PLUS_EXTN dependencies on GMS_AWARDS_ALL

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

1397: SELECT idc_schedule_id,
1398: cost_ind_sch_fixed_date
1399: INTO l_rate_sch_id,
1400: l_sch_fixed_date
1401: FROM gms_awards_all -- bug 3117503. changed to _all.
1402: WHERE award_id = x_award_id;
1403: END IF; -- Bug 2097676: Multiple IDC Build
1404:
1405: IF l_rate_sch_id is not null THEN

Line 3617: gms_awards_all ga,

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

Line 4122: gms_awards_all ga

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

Line 4274: gms_awards_all ga,

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