APPS.GMS_BUDGET_UTILS dependencies on PA_TASKS

Line 529: pa_tasks t,

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'
533: and a.task_id = t.task_id

Line 796: pa_tasks t,

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
800: AND v.budget_type_code = x_budget_type

Line 1099: from pa_tasks

1095: from dual
1096: where x_task_id is null
1097: union
1098: select 'T'
1099: from pa_tasks
1100: where x_task_id is not null
1101: and task_id = x_task_id
1102: and parent_task_id is null
1103: union

Line 1105: from pa_tasks

1101: and task_id = x_task_id
1102: and parent_task_id is null
1103: union
1104: select 'M'
1105: from pa_tasks
1106: where x_task_id is not null
1107: and task_id = x_task_id
1108: and parent_task_id is not null
1109: and exists (select 'X'

Line 1110: from pa_tasks

1106: where x_task_id is not null
1107: and task_id = x_task_id
1108: and parent_task_id is not null
1109: and exists (select 'X'
1110: from pa_tasks
1111: where parent_task_id = x_task_id)
1112: union
1113: select 'L'
1114: from dual

Line 1117: from pa_tasks

1113: select 'L'
1114: from dual
1115: where x_task_id is not null
1116: and not exists (select 'X'
1117: from pa_tasks
1118: where parent_task_id = x_task_id);
1119:
1120: cursor get_totals is
1121: select labor_quantity,

Line 1133: from pa_tasks t,

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

Line 1151: from pa_tasks

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
1152: start with task_id = x_task_id
1153: connect by prior task_id = parent_task_id)
1154: and a.resource_assignment_id = l.resource_assignment_id
1155: union

Line 1328: FROM pa_tasks

1324: ( p_task_id NUMBER )
1325: IS
1326: SELECT start_date
1327: , completion_date
1328: FROM pa_tasks
1329: WHERE task_id = p_task_id;
1330:
1331: --Added For Bug 2200867
1332: CURSOR l_award_dates_csr

Line 1854: FROM pa_tasks

1850: FUNCTION get_task_number(P_task_Id IN NUMBER) RETURN VARCHAR2 IS
1851:
1852: CURSOR c_task_name IS
1853: SELECT task_name
1854: FROM pa_tasks
1855: WHERE task_id = P_task_Id;
1856:
1857: Begin
1858: If p_task_id = g_task_id then