eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BUDGET_UTILS dependencies on PA_TASKS

Line 1156: , pa_tasks t

1152: from dual
1153: where exists
1154: (select 1
1155: from pa_budget_versions bv
1156: , pa_tasks t
1157: , pa_resource_assignments a
1158: where a.budget_version_id = bv.budget_version_id
1159: and a.task_id = t.task_id
1160: and t.top_task_id = x_task_id

Line 1174: , pa_tasks t

1170: from dual
1171: where exists
1172: (select 1
1173: from pa_budget_versions bv
1174: , pa_tasks t
1175: , pa_resource_assignments a
1176: where a.budget_version_id = bv.budget_version_id
1177: and a.task_id = t.task_id
1178: and t.top_task_id = x_task_id

Line 1201: Changing reference of pa_tasks to pa_struct_task_wbs_v below */

1197:
1198: IF (x_budget_type_code = 'AC')
1199: THEN
1200: /* Changes for FP.M, Tracking Bug No - 3354518.
1201: Changing reference of pa_tasks to pa_struct_task_wbs_v below */
1202:
1203: /* Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks in
1204: * the following select to avoid full index scan on PA_PROJ_ELEM_VER_SCHEDULE_N1
1205: */

Line 1203: /* Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks in

1199: THEN
1200: /* Changes for FP.M, Tracking Bug No - 3354518.
1201: Changing reference of pa_tasks to pa_struct_task_wbs_v below */
1202:
1203: /* Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks in
1204: * the following select to avoid full index scan on PA_PROJ_ELEM_VER_SCHEDULE_N1
1205: */
1206: select 1
1207: into dummy

Line 1212: ,pa_tasks t --Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks

1208: from dual
1209: where exists
1210: (select 1
1211: from pa_budget_versions bv
1212: ,pa_tasks t --Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks
1213: -- , pa_struct_task_wbs_v t -- Adding for FP.M, Tracking Bug No - 3354518.
1214: ,pa_resource_assignments a
1215: where a.budget_version_id = bv.budget_version_id
1216: and a.task_id = t.task_id

Line 1228: Changing reference of pa_tasks to pa_struct_task_wbs_v below */

1224:
1225: ELSE
1226: -- Must be 'AR'
1227: /* Changes for FP.M, Tracking Bug No - 3354518.
1228: Changing reference of pa_tasks to pa_struct_task_wbs_v below */
1229:
1230: /* Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks in
1231: * the following select to avoid full index scan on PA_PROJ_ELEM_VER_SCHEDULE_N1
1232: */

Line 1230: /* Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks in

1226: -- Must be 'AR'
1227: /* Changes for FP.M, Tracking Bug No - 3354518.
1228: Changing reference of pa_tasks to pa_struct_task_wbs_v below */
1229:
1230: /* Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks in
1231: * the following select to avoid full index scan on PA_PROJ_ELEM_VER_SCHEDULE_N1
1232: */
1233: select 1
1234: into dummy

Line 1239: ,pa_tasks t -- Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks

1235: from dual
1236: where exists
1237: (select 1
1238: from pa_budget_versions bv
1239: ,pa_tasks t -- Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks
1240: --, pa_struct_task_wbs_v t -- Adding for FP.M, Tracking Bug No - 3354518.
1241: ,pa_resource_assignments a
1242: where a.budget_version_id = bv.budget_version_id
1243: and a.task_id = t.task_id

Line 1279: , pa_tasks t

1275: where exists
1276: (select 1
1277: from pa_budget_versions bv
1278: , pa_budget_types bt
1279: , pa_tasks t
1280: , pa_resource_assignments a
1281: where a.budget_version_id = bv.budget_version_id
1282: and a.task_id = t.task_id
1283: and t.top_task_id = x_task_id

Line 1303: Changing reference of pa_tasks to pa_struct_task_wbs_v below*/

1299: -- x_budget_type_code IS NULL. Assume Get FP Model DAta
1300:
1301: BEGIN
1302: /* Changes for FP.M, Tracking Bug No - 3354518.
1303: Changing reference of pa_tasks to pa_struct_task_wbs_v below*/
1304:
1305: /* Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks in
1306: * the following select to avoid full index scan on PA_PROJ_ELEM_VER_SCHEDULE_N1
1307: */

Line 1305: /* Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks in

1301: BEGIN
1302: /* Changes for FP.M, Tracking Bug No - 3354518.
1303: Changing reference of pa_tasks to pa_struct_task_wbs_v below*/
1304:
1305: /* Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks in
1306: * the following select to avoid full index scan on PA_PROJ_ELEM_VER_SCHEDULE_N1
1307: */
1308:
1309: select 1

Line 1315: ,pa_tasks t -- Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks

1311: from dual
1312: where exists
1313: (select 1
1314: from pa_budget_versions bv
1315: ,pa_tasks t -- Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks
1316: --, pa_struct_task_wbs_v t -- Adding for FP.M, Tracking Bug No - 3354518.
1317: ,pa_resource_assignments a
1318: where a.budget_version_id = bv.budget_version_id
1319: and a.task_id = t.task_id

Line 1552: pa_tasks t,

1548: labor_qty,
1549: revenue_amount
1550: FROM pa_budget_lines l,
1551: pa_resource_assignments a,
1552: pa_tasks t,
1553: pa_budget_versions v
1554: WHERE v.project_id = x_project_id
1555: AND v.budget_type_code = x_budget_type
1556: AND v.budget_status_code = decode(budget_status, 'B', 'B',

Line 3541: from pa_tasks

3537: from dual
3538: where x_task_id is null
3539: union
3540: select 'T'
3541: from pa_tasks
3542: where x_task_id is not null
3543: and task_id = x_task_id
3544: and parent_task_id is null
3545: union

Line 3547: from pa_tasks

3543: and task_id = x_task_id
3544: and parent_task_id is null
3545: union
3546: select 'M'
3547: from pa_tasks
3548: where x_task_id is not null
3549: and task_id = x_task_id
3550: and parent_task_id is not null
3551: and exists (select 'X'

Line 3552: from pa_tasks

3548: where x_task_id is not null
3549: and task_id = x_task_id
3550: and parent_task_id is not null
3551: and exists (select 'X'
3552: from pa_tasks
3553: where parent_task_id = x_task_id)
3554: union
3555: select 'L'
3556: from dual

Line 3559: from pa_tasks

3555: select 'L'
3556: from dual
3557: where x_task_id is not null
3558: and not exists (select 'X'
3559: from pa_tasks
3560: where parent_task_id = x_task_id);
3561:
3562: --Bug 4176059: Performance Fix: FP.M-B12
3563: cursor get_project_totals is

Line 3578: from pa_tasks t,

3574: select SUM(DECODE(a.TRACK_AS_LABOR_FLAG,'Y',NVL(l.QUANTITY,0),0)),
3575: SUM(NVL(l.RAW_COST,0)),
3576: SUM(NVL(l.BURDENED_COST,0)),
3577: SUM(NVL(l.REVENUE,0))
3578: from pa_tasks t,
3579: pa_budget_lines l ,
3580: pa_resource_assignments a
3581: where v_rollup_flag = 'T' -- Top Task Level
3582: and a.budget_version_id = x_budget_version_id

Line 3599: from pa_tasks

3595: pa_resource_assignments a
3596: where v_rollup_flag = 'M' -- Middle Task Level
3597: and a.budget_version_id = x_budget_version_id
3598: and a.task_id in (select task_id
3599: from pa_tasks
3600: start with task_id = x_task_id
3601: connect by prior task_id = parent_task_id)
3602: and a.resource_assignment_id = l.resource_assignment_id
3603: and NVL(a.RESOURCE_ASSIGNMENT_TYPE,'USER_ENTERED') = 'USER_ENTERED';