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

Line 1282: pa_tasks task

1278: NVL(c_gen_etc_source_code,
1279: DECODE(p_calling_process, 'COPY_ACTUALS', NULL,task.GEN_ETC_SOURCE_CODE)) -- Bug 4193368 for staffing plan src should not be
1280: -- based on task's etc source
1281: FROM PA_FP_PLANNING_RES_TMP1 tmp1,
1282: pa_tasks task
1283: WHERE nvl(tmp1.task_id,0) > 0
1284: AND tmp1.task_id = task.task_id
1285: AND NOT EXISTS (
1286: SELECT /*+ INDEX(tmp1,PA_RESOURCE_ASSIGNMENTS_U2)*/ 1 -- Changed For Bug10331270

Line 1333: pa_tasks task, pa_tasks task_t

1329: NVL(c_gen_etc_source_code,
1330: DECODE(p_calling_process, 'COPY_ACTUALS', NULL,task_t.GEN_ETC_SOURCE_CODE)) -- Bug 4193368 for staffing plan src should not be
1331: -- based on task's etc source
1332: FROM PA_FP_PLANNING_RES_TMP1 tmp1,
1333: pa_tasks task, pa_tasks task_t
1334: WHERE nvl(tmp1.task_id,0) > 0
1335: AND tmp1.task_id = task.task_id
1336: AND task.top_task_id = task_t.task_id
1337: AND NOT EXISTS (

Line 1404: pa_tasks task

1400: FROM PA_FP_CALC_AMT_TMP1 tmp,
1401: PA_RESOURCE_ASSIGNMENTS PRA
1402: WHERE tmp.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID
1403: GROUP BY mapped_fin_task_id,TARGET_RLM_ID,PRA.CBS_ELEMENT_ID) tmp1,
1404: pa_tasks task
1405: WHERE nvl(tmp1.task_id,0) > 0
1406: AND tmp1.task_id = task.task_id
1407: AND NOT EXISTS (
1408: SELECT /*+ INDEX(tmp1,PA_RESOURCE_ASSIGNMENTS_U2)*/ 1 -- Changed For Bug10331270

Line 1441: pa_tasks task, pa_tasks task_t

1437: FROM PA_FP_CALC_AMT_TMP1 tmp,
1438: PA_RESOURCE_ASSIGNMENTS PRA
1439: WHERE tmp.RESOURCE_ASSIGNMENT_ID = PRA.RESOURCE_ASSIGNMENT_ID
1440: GROUP BY mapped_fin_task_id,TARGET_RLM_ID,PRA.CBS_ELEMENT_ID) tmp1,
1441: pa_tasks task, pa_tasks task_t
1442: WHERE nvl(tmp1.task_id,0) > 0
1443: AND tmp1.task_id = task.task_id
1444: AND task.top_task_id = task_t.task_id
1445: AND NOT EXISTS (

Line 1908: pa_tasks t

1904: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1
1905: SET resource_assignment_id =
1906: (SELECT resource_assignment_id
1907: FROM pa_resource_assignments ra,
1908: pa_tasks t
1909: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID
1910: AND ra.project_id = P_PROJECT_ID
1911: AND tmp1.task_id = t.task_id
1912: AND t.top_task_id = ra.task_id