DBA Data[Home] [Help]

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 2181: pa_map_wp_to_fin_tasks_v map_wp_fin,

2177: INTO P_project_currency_code,
2178: P_project_rate_type
2179: FROM pa_projects_all proj,
2180: pa_tasks task,
2181: pa_map_wp_to_fin_tasks_v map_wp_fin,
2182: pa_implementations_all imp
2183: WHERE proj.project_id = p_project_id
2184: AND task.task_id = map_wp_fin.mapped_fin_task_id
2185: AND map_wp_fin.proj_element_id = p_task_id

Line 2261: ,pa_map_wp_to_fin_tasks_v map_wp_fin

2257: BEGIN
2258: SELECT task.project_rate_date
2259: INTO P_project_rate_date
2260: FROM pa_tasks task
2261: ,pa_map_wp_to_fin_tasks_v map_wp_fin
2262: WHERE task.task_id = map_wp_fin.mapped_fin_task_id
2263: AND map_wp_fin.proj_element_id = p_task_id
2264: AND map_wp_fin.parent_structure_version_id = p_structure_version_id;
2265: EXCEPTION