DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PUB dependencies on PA_FP_FCST_GEN_TMP1

Line 2415: --Top Task Planning level then the task ids in PA_FP_FCST_GEN_TMP1 should be updated

2411: DELETE FROM pa_map_wp_to_fin_tasks_tmp;
2412:
2413: --Bug 6407972
2414: --Bug 5929269. If the plan version into whihc amounts are being forecasted has
2415: --Top Task Planning level then the task ids in PA_FP_FCST_GEN_TMP1 should be updated
2416: --to the top task ids since the ETC should now be calculated for top tasks
2417: IF p_fp_cols_rec.x_fin_plan_level_code = 'T' THEN
2418:
2419: UPDATE pa_fp_fcst_gen_tmp1 tmp

Line 2419: UPDATE pa_fp_fcst_gen_tmp1 tmp

2415: --Top Task Planning level then the task ids in PA_FP_FCST_GEN_TMP1 should be updated
2416: --to the top task ids since the ETC should now be calculated for top tasks
2417: IF p_fp_cols_rec.x_fin_plan_level_code = 'T' THEN
2418:
2419: UPDATE pa_fp_fcst_gen_tmp1 tmp
2420: SET tmp.project_element_id = (SELECT pt.top_task_id
2421: FROM pa_tasks pt
2422: WHERE tmp.project_element_id = pt.task_id)
2423: WHERE tmp.data_type_code = 'ETC_FP'