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_FP_ROLLUP_PKG dependencies on PA_TASKS

Line 309: FROM pa_resource_assignments pra, pa_tasks pt

305: SELECT pra.resource_assignment_id
306: ,pra.parent_assignment_id
307: ,decode(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_ROLLED_UP,
308: PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS,pra.unit_of_measure) unit_of_measure
309: FROM pa_resource_assignments pra, pa_tasks pt
310: WHERE pra.budget_version_id = p_budget_version_id
311: AND pra.task_id = pt.task_id
312: AND pra.resource_list_member_id in (0,l_uncat_rlm_id) -- Added for bug #2723515
313: and pt.wbs_level = p_curr_rollup_level

Line 859: ,pa_tasks pt

855: ,sum(nvl(pra.total_plan_quantity,0)) quantity /* no decode required on quantity */
856: ,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS -- Modified for bug #2697999
857: ,'Y' -- Modified for bug #2697999
858: FROM pa_resource_assignments pra
859: ,pa_tasks pt
860: WHERE pra.budget_version_id = c_budget_version_id
861: AND pra.resource_list_member_id IN (c_uncat_rlm_id,0)
862: -- AND resource_assignment_id > c_curr_res_assignment_id /* mano: this is wrong with new logic */
863: AND pt.wbs_level = c_process_wbs_level /* added due to bug during UT */

Line 919: pa_tasks pt

915: ,sum(nvl(total_plan_quantity,0)) quantity
916: ,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS unit_of_measure --Modified for bug #2697999
917: ,'Y' track_as_labor_flag --Modified for bug #2697999
918: FROM pa_resource_assignments pra,
919: pa_tasks pt
920: WHERE pra.budget_version_id = p_budget_Version_id
921: AND pra.resource_list_member_id in (l_uncat_rlm_id,0)
922: AND pra.project_id = pt.project_id -- Fixed for #2807678
923: AND pra.task_id = pt.task_id

Line 1295: from pa_tasks

1291: l_curr_wbs_level := null;
1292:
1293: select max(wbs_level)
1294: into l_curr_wbs_level
1295: from pa_tasks
1296: where project_id = l_project_id;
1297:
1298: LOOP
1299: EXIT WHEN l_curr_wbs_level = 1;

Line 1432: join with PA_TASKS table as there would be no record in PA_TASKS

1428:
1429: ELSE
1430:
1431: /* #2598502: If the Planning Level is 'Project' then we should not
1432: join with PA_TASKS table as there would be no record in PA_TASKS
1433: table with Task_ID as 0. We should also have no condition for
1434: checking the resource list member id. */
1435:
1436: pa_debug.g_err_stage := 'Creating Project Level Record - 1';

Line 1679: ,pa_tasks t

1675: UPDATE pa_resource_assignments pra1
1676: SET parent_assignment_id =
1677: (SELECT resource_assignment_id
1678: FROM pa_resource_assignments pra2
1679: ,pa_tasks t
1680: WHERE pra2.task_id = t.parent_task_id
1681: AND pra1.task_id = t.task_id
1682: AND pra2.budget_version_id = p_budget_version_id
1683: AND pra2.resource_list_member_id = 0

Line 1779: FROM pa_tasks

1775: UPDATE pa_resource_assignments pra
1776: SET parent_assignment_id = p_proj_ra_id
1777: WHERE task_id in
1778: (SELECT top_task_id
1779: FROM pa_tasks
1780: WHERE project_id = l_project_id)
1781: AND budget_version_id = p_budget_version_id
1782: AND project_id = l_project_id -- bug#2708524
1783: AND resource_list_member_id IN (l_uncat_rlm_id,0)

Line 2174: from pa_tasks

2170: l_curr_rollup_level := 1;
2171: ELSE /* planning level is lowest task or top and lowest */
2172: select max(wbs_level)
2173: into l_curr_rollup_level
2174: from pa_tasks
2175: where project_id = l_project_id;
2176: END IF;
2177:
2178: IF l_uncat_flag <> 'Y' THEN /* resource list is attached */

Line 2605: ,pa_tasks pt

2601: ,c_budget_version_id IN NUMBER --bug#2708524
2602: ,c_project_id IN NUMBER) IS --bug#2708524
2603: SELECT PARENT_TASK_ID TASK_ID
2604: FROM pa_resource_assignments pra
2605: ,pa_tasks pt
2606: WHERE pra.resource_assignment_id IN
2607: (select resource_assignment_id FROM pa_fp_ra_map_tmp )
2608: AND pra.project_id = c_project_id --bug#2708524
2609: AND pra.budget_version_id = c_budget_version_id --bug#2708524

Line 3043: from pa_tasks

3039:
3040: l_curr_wbs_level := 0;
3041: select max(wbs_level)
3042: into l_curr_wbs_level
3043: from pa_tasks
3044: where project_id = l_project_id;
3045:
3046: pa_debug.g_err_stage := 'l_curr_wbs_level =' || l_curr_wbs_level ;
3047: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3070: ,pa_tasks t

3066: UPDATE /*+ INDEX(pra1 PA_RESOURCE_ASSIGNMENTS_U1)*/ pa_resource_assignments pra1 --Bug 2782166
3067: SET parent_assignment_id =
3068: (select resource_assignment_id
3069: from pa_resource_assignments pra2
3070: ,pa_tasks t
3071: where pra2.task_id = t.parent_task_id
3072: and pra1.task_id = t.task_id
3073: and pra2.budget_version_id = p_budget_version_id) /* manokuma: fixed during ut */
3074: WHERE resource_assignment_id in

Line 3797: from pa_tasks

3793: l_curr_rollup_level := 1;
3794: ELSE /* planning level is lowest task or top and lowest */
3795: select max(wbs_level)
3796: into l_curr_rollup_level
3797: from pa_tasks
3798: where project_id = l_project_id;
3799: END IF;
3800:
3801: IF l_uncat_flag <> 'Y' THEN /* resource list is attached */

Line 4421: l_task_id pa_tasks.task_id%type;

4417: l_msg_index_out NUMBER;
4418: l_return_status VARCHAR2(2000);
4419: l_debug_mode VARCHAR2(30);
4420:
4421: l_task_id pa_tasks.task_id%type;
4422: l_resource_list_member_id pa_resource_list_members.resource_list_member_id%type;
4423:
4424: --Bug # 2615807.
4425: l_project_currency_code pa_projects_all.project_currency_code%type;