APPS.PA_FP_GEN_FCST_AMT_PUB dependencies on PA_MAP_WP_TO_FIN_TASKS_TMP

Line 2213: DELETE FROM pa_map_wp_to_fin_tasks_tmp;

2209: -- Changes done for bug#10406949 ,FP Bug#12800007
2210: --IF (l_proj_struc_sharing_code = 'SPLIT_MAPPING') or (l_proj_struc_sharing_code = 'SPLIT_NO_MAPPING') THEN
2211: --bug#13829368 modified the if condition to support SHARE_PARTIAL structure_sharing_code
2212: IF (l_proj_struc_sharing_code = 'SPLIT_MAPPING') or (l_proj_struc_sharing_code = 'SHARE_PARTIAL') THEN
2213: DELETE FROM pa_map_wp_to_fin_tasks_tmp;
2214: INSERT INTO pa_map_wp_to_fin_tasks_tmp (SELECT * FROM pa_map_wp_to_fin_tasks_v WHERE project_id = P_PROJECT_ID);
2215: END IF;
2216:
2217: /* hr_utility.trace('--Before traverse any task node');

Line 2214: INSERT INTO pa_map_wp_to_fin_tasks_tmp (SELECT * FROM pa_map_wp_to_fin_tasks_v WHERE project_id = P_PROJECT_ID);

2210: --IF (l_proj_struc_sharing_code = 'SPLIT_MAPPING') or (l_proj_struc_sharing_code = 'SPLIT_NO_MAPPING') THEN
2211: --bug#13829368 modified the if condition to support SHARE_PARTIAL structure_sharing_code
2212: IF (l_proj_struc_sharing_code = 'SPLIT_MAPPING') or (l_proj_struc_sharing_code = 'SHARE_PARTIAL') THEN
2213: DELETE FROM pa_map_wp_to_fin_tasks_tmp;
2214: INSERT INTO pa_map_wp_to_fin_tasks_tmp (SELECT * FROM pa_map_wp_to_fin_tasks_v WHERE project_id = P_PROJECT_ID);
2215: END IF;
2216:
2217: /* hr_utility.trace('--Before traverse any task node');
2218: hr_utility.trace('--we have :'||l_task_id_tab.count||' task ids'); */

Line 2411: DELETE FROM pa_map_wp_to_fin_tasks_tmp;

2407: END IF;
2408: END LOOP;
2409:
2410: -- Changes done for bug#10406949 , FP Bug#12800007
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