APPS.GMS_BUDGET_UTILS dependencies on GMS_BUDGET_LINES

Line 611: from gms_budget_lines_v a, gms_budget_lines_v b

607: x_err_code IN OUT NOCOPY NUMBER) is
608: v_temp varchar2(1);
609: cursor c is
610: select a.resource_name
611: from gms_budget_lines_v a, gms_budget_lines_v b
612: where a.budget_version_id = x_budget_version_id
613: and b.budget_version_id = x_budget_version_id
614: and a.task_id||null = b.task_id||null
615: -- and a.resource_list_member_id = b.resource_list_member_id Bug 2601648

Line 651: gms_budget_lines a2,

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
655: and b1.resource_assignment_id = b2.resource_assignment_id

Line 653: gms_budget_lines b2

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
657: and a1.budget_version_id = x_budget_version_id

Line 794: FROM gms_budget_lines l,

790: INTO raw_cost,
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

Line 1134: gms_budget_lines l ,

1130: SUM(NVL(l.RAW_COST,0)),
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

Line 1146: from gms_budget_lines l,

1142: select SUM(DECODE(a.TRACK_AS_LABOR_FLAG,'Y',NVL(l.QUANTITY,0),0)),
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

Line 1160: from gms_budget_lines l,

1156: select SUM(DECODE(a.TRACK_AS_LABOR_FLAG,'Y',NVL(l.QUANTITY,0),0)),
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