APPS.PA_MULTI_CURRENCY_TXN dependencies on PA_MAP_WP_TO_FIN_TASKS_V

Line 272: pa_map_wp_to_fin_tasks_v map_wp_fin,

268: INTO P_projfunc_currency_code,
269: P_projfunc_cost_rate_type
270: FROM pa_projects_all proj,
271: pa_tasks task,
272: pa_map_wp_to_fin_tasks_v map_wp_fin,
273: pa_implementations_all imp
274: WHERE proj.project_id = map_wp_fin.project_id
275: AND task.task_id(+) = map_wp_fin.mapped_fin_task_id
276: AND map_wp_fin.proj_element_id = p_task_id

Line 287: pa_map_wp_to_fin_tasks_v map_wp_fin,

283: INTO P_projfunc_currency_code,
284: P_projfunc_cost_rate_type
285: FROM pa_projects_all proj,
286: pa_tasks task,
287: pa_map_wp_to_fin_tasks_v map_wp_fin,
288: pa_implementations_all imp
289: WHERE proj.project_id = p_project_id
290: AND task.task_id = map_wp_fin.mapped_fin_task_id
291: AND map_wp_fin.proj_element_id = p_task_id

Line 442: ,pa_map_wp_to_fin_tasks_v map_wp_fin

438: BEGIN
439: SELECT task.taskfunc_cost_rate_date
440: INTO P_projfunc_cost_rate_date
441: FROM pa_tasks task
442: ,pa_map_wp_to_fin_tasks_v map_wp_fin
443: WHERE task.task_id = map_wp_fin.mapped_fin_task_id
444: AND map_wp_fin.proj_element_id = P_task_id
445: AND map_wp_fin.parent_structure_version_id = p_structure_version_id;
446: EXCEPTION

Line 527: pa_map_wp_to_fin_tasks_v map_wp_fin,

523: NULL))
524: INTO P_projfunc_cost_rate_date
525: FROM pa_projects_all proj,
526: pa_tasks task,
527: pa_map_wp_to_fin_tasks_v map_wp_fin,
528: pa_implementations imp
529: WHERE proj.project_id = map_wp_fin.project_id
530: AND task.task_id(+) = map_wp_fin.mapped_fin_task_id
531: AND map_wp_fin.proj_element_id = p_task_id;

Line 537: ,pa_map_wp_to_fin_tasks_v map_wp_fin

533: BEGIN
534: SELECT task.taskfunc_cost_rate_date
535: INTO P_projfunc_cost_rate_date
536: FROM pa_tasks task
537: ,pa_map_wp_to_fin_tasks_v map_wp_fin
538: WHERE task.task_id = map_wp_fin.mapped_fin_task_id
539: AND map_wp_fin.proj_element_id = p_task_id
540: AND map_wp_fin.parent_structure_version_id = p_structure_version_id;
541: EXCEPTION

Line 2270: pa_map_wp_to_fin_tasks_v map_wp_fin,

2266: INTO P_project_currency_code,
2267: P_project_rate_type
2268: FROM pa_projects_all proj,
2269: pa_tasks task,
2270: pa_map_wp_to_fin_tasks_v map_wp_fin,
2271: pa_implementations_all imp
2272: WHERE proj.project_id = p_project_id
2273: AND task.task_id = map_wp_fin.mapped_fin_task_id
2274: AND map_wp_fin.proj_element_id = p_task_id

Line 2350: ,pa_map_wp_to_fin_tasks_v map_wp_fin

2346: BEGIN
2347: SELECT task.project_rate_date
2348: INTO P_project_rate_date
2349: FROM pa_tasks task
2350: ,pa_map_wp_to_fin_tasks_v map_wp_fin
2351: WHERE task.task_id = map_wp_fin.mapped_fin_task_id
2352: AND map_wp_fin.proj_element_id = p_task_id
2353: AND map_wp_fin.parent_structure_version_id = p_structure_version_id;
2354: EXCEPTION