APPS.GMS_BUDGET_UTILS dependencies on GMS_BUDGET_VERSIONS

Line 30: from gms_budget_versions

26: || '><' || x_budget_type_code || '>' ;
27:
28: select budget_version_id
29: into x_budget_version_id
30: from gms_budget_versions
31: where project_id = x_project_id
32: and award_id = x_award_id
33: and budget_type_code = x_budget_type_code
34: and budget_status_code in ('W', 'S');

Line 81: from gms_budget_versions

77: || '><' || x_budget_type_code || '>' ;
78:
79: select budget_version_id
80: into x_budget_version_id
81: from gms_budget_versions
82: where project_id = x_project_id
83: and award_id = x_award_id
84: and budget_type_code = x_budget_type_code
85: and current_flag = 'Y';

Line 134: from gms_budget_versions

130: || '><' || x_award_id || '>' ;
131:
132: select budget_version_id
133: into x_budget_version_id
134: from gms_budget_versions
135: where project_id = x_project_id
136: and award_id = x_award_id
137: and budget_type_code = x_budget_type_code
138: and current_original_flag = 'Y';

Line 202: from gms_budget_versions

198: -- baselined budget exists, use it to get the resource list
199:
200: select resource_list_id
201: into x_resource_list_id
202: from gms_budget_versions
203: where budget_version_id = x_baselined_version_id;
204:
205: elsif (x_err_code > 0) then
206:

Line 461: from gms_budget_versions

457: into dummy
458: from sys.dual
459: where exists
460: (select 1
461: from gms_budget_versions
462: where project_id = x_project_id
463: and award_id = x_award_id
464: and budget_type_code =
465: nvl(x_budget_type_code, budget_type_code));

Line 474: from gms_budget_versions

470: into dummy
471: from sys.dual
472: where exists
473: (select 1
474: from gms_budget_versions
475: where project_id = x_project_id
476: and award_id = x_award_id
477: and budget_type_code =
478: nvl(x_budget_type_code, budget_type_code)

Line 513: from gms_budget_versions v,

509: into dummy
510: from sys.dual
511: where exists
512: (select 1
513: from gms_budget_versions v,
514: gms_resource_assignments a
515: where a.task_id = x_task_id
516: and v.award_id = x_award_id
517: and v.budget_version_id = a.budget_version_id

Line 528: from gms_budget_versions v,

524: into dummy
525: from sys.dual
526: where exists
527: (select 1
528: from gms_budget_versions v,
529: pa_tasks t,
530: gms_resource_assignments a
531: where a.budget_version_id = v.budget_version_id
532: and v.budget_status_code = 'B'

Line 727: FROM gms_budget_versions b

723: INTO raw_cost,
724: burdened_cost,
725: labor_qty,
726: revenue_amount
727: FROM gms_budget_versions b
728: WHERE b.project_id = x_project_id
729: AND b.award_id = x_award_id
730: AND b.budget_type_code = x_budget_type
731: AND b.budget_status_code = decode(budget_status, 'B', 'B',

Line 797: gms_budget_versions v

793: revenue_amount
794: FROM gms_budget_lines l,
795: gms_resource_assignments a,
796: pa_tasks t,
797: gms_budget_versions v
798: WHERE v.project_id = x_project_id
799: AND v.award_id = x_award_id
800: AND v.budget_type_code = x_budget_type
801: AND v.budget_status_code = decode(budget_status, 'B', 'B',

Line 1125: from gms_budget_versions

1121: select labor_quantity,
1122: raw_cost,
1123: burdened_cost,
1124: revenue
1125: from gms_budget_versions
1126: where v_rollup_flag = 'P' -- Project Level
1127: and budget_version_id = x_budget_version_id
1128: union
1129: select SUM(DECODE(a.TRACK_AS_LABOR_FLAG,'Y',NVL(l.QUANTITY,0),0)),