DBA Data[Home] [Help]

APPS.PA_FP_COPY_ACTUALS_PUB dependencies on PA_TASKS

Line 1237: pa_tasks task

1233: NVL(c_gen_etc_source_code,
1234: DECODE(p_calling_process, 'COPY_ACTUALS', NULL,task.GEN_ETC_SOURCE_CODE)) -- Bug 4193368 for staffing plan src should not be
1235: -- based on task's etc source
1236: FROM PA_FP_PLANNING_RES_TMP1 tmp1,
1237: pa_tasks task
1238: WHERE nvl(tmp1.task_id,0) > 0
1239: AND tmp1.task_id = task.task_id
1240: AND NOT EXISTS (
1241: SELECT /*+ INDEX(tmp1,PA_FP_PLANNING_RES_TMP1_N2)*/ 1

Line 1282: pa_tasks task, pa_tasks task_t

1278: NVL(c_gen_etc_source_code,
1279: DECODE(p_calling_process, 'COPY_ACTUALS', NULL,task_t.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, pa_tasks task_t
1283: WHERE nvl(tmp1.task_id,0) > 0
1284: AND tmp1.task_id = task.task_id
1285: AND task.top_task_id = task_t.task_id
1286: AND NOT EXISTS (

Line 1667: pa_tasks t

1663: UPDATE PA_FP_PLANNING_RES_TMP1 tmp1
1664: SET resource_assignment_id =
1665: (SELECT resource_assignment_id
1666: FROM pa_resource_assignments ra,
1667: pa_tasks t
1668: WHERE ra.budget_version_id = P_BUDGET_VERSION_ID
1669: AND ra.project_id = P_PROJECT_ID
1670: AND tmp1.task_id = t.task_id
1671: AND t.top_task_id = ra.task_id