[Home] [Help]
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
518: and v.budget_type_code =
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'
533: and a.task_id = t.task_id
534: and t.top_task_id = x_task_id
569: from sys.dual
570: where exists
571: (select 1
572: from pa_resource_list_members m,
573: gms_resource_assignments a
574: where m.parent_member_id = x_resource_list_member_id
575: and m.resource_list_member_id = a.resource_list_member_id
576: and a.budget_version_id = x_budget_version_id
577: and a.task_id = x_task_id);
581: into dummy
582: from sys.dual
583: where exists
584: (select 1
585: from gms_resource_assignments a
586: where a.budget_version_id = x_budget_version_id
587: and a.task_id = x_task_id
588: and a.resource_list_member_id = x_parent_member_id);
589:
646: v_temp varchar2(1);
647: l_resource_list_member_id number;
648: cursor c is
649: select a1.resource_list_member_id
650: from gms_resource_assignments a1,
651: gms_budget_lines a2,
652: gms_resource_assignments b1,
653: gms_budget_lines b2
654: where a1.resource_assignment_id = a2.resource_assignment_id
648: cursor c is
649: select a1.resource_list_member_id
650: from gms_resource_assignments a1,
651: gms_budget_lines a2,
652: gms_resource_assignments b1,
653: gms_budget_lines b2
654: where a1.resource_assignment_id = a2.resource_assignment_id
655: and b1.resource_assignment_id = b2.resource_assignment_id
656: and a1.budget_version_id = b1.budget_version_id
791: burdened_cost,
792: labor_qty,
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
940: into l_dummy
941: from sys.dual
942: where exists
943: (select 1
944: from gms_resource_assignments
945: where budget_version_id = p_draft_version_id);
946:
947: EXCEPTION
948: WHEN NO_DATA_FOUND THEN
1131: SUM(NVL(l.BURDENED_COST,0)),
1132: SUM(NVL(l.REVENUE,0))
1133: from pa_tasks t,
1134: gms_budget_lines l ,
1135: gms_resource_assignments a
1136: where v_rollup_flag = 'T' -- Top Task Level
1137: and a.budget_version_id = x_budget_version_id
1138: and a.task_id = t.task_id
1139: and t.top_task_id = x_task_id
1143: SUM(NVL(l.RAW_COST,0)),
1144: SUM(NVL(l.BURDENED_COST,0)),
1145: SUM(NVL(l.REVENUE,0))
1146: from gms_budget_lines l,
1147: gms_resource_assignments a
1148: where v_rollup_flag = 'M' -- Middle Task Level
1149: and a.budget_version_id = x_budget_version_id
1150: and a.task_id in (select task_id
1151: from pa_tasks
1157: SUM(NVL(l.RAW_COST,0)),
1158: SUM(NVL(l.BURDENED_COST,0)),
1159: SUM(NVL(l.REVENUE,0))
1160: from gms_budget_lines l,
1161: gms_resource_assignments a
1162: where v_rollup_flag = 'L' -- Lowest Task Level
1163: and a.budget_version_id = x_budget_version_id
1164: and a.task_id = x_task_id
1165: and a.resource_assignment_id = l.resource_assignment_id;