DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PUB dependencies on PA_MAP_WP_TO_FIN_TASKS_V

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'); */