[Home] [Help]
254: proj.projfunc_cost_rate_type), imp.default_rate_type))
255: INTO P_projfunc_currency_code,
256: P_projfunc_cost_rate_type
257: FROM pa_projects_all proj,
258: pa_tasks task,
259: pa_implementations_all imp
260: WHERE proj.project_id = task.project_id
261: AND task.task_id = P_task_id
262: AND NVL(proj.org_id, -99) = NVL(imp.org_id, -99);
267: proj.projfunc_cost_rate_type), imp.default_rate_type))
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
282: proj.projfunc_cost_rate_type), imp.default_rate_type))
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
344: proj.projfunc_cost_rate_type), imp.default_rate_type))
345: INTO P_projfunc_currency_code,
346: P_projfunc_cost_rate_type
347: FROM pa_projects_all proj,
348: pa_tasks task,
349: pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all
350: WHERE proj.project_id = task.project_id
351: AND task.task_id = P_task_id
352: AND NVL(proj.org_id,-99) = NVL(imp.org_id,-99); -- bug 7579126
428: pa_utils2.get_pa_date(P_EI_date,
429: sysdate, imp.org_id))) /**CBGA**/
430: INTO P_projfunc_cost_rate_date
431: FROM pa_projects_all proj,
432: pa_tasks task,
433: pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all
434: WHERE task.task_id = P_task_id
435: AND proj.project_id = task.project_id
436: AND NVL(proj.org_id,-99) = NVL(imp.org_id,-99); -- bug 7579126
437: ELSE
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;
508: 'E', P_EI_date, 'P',
509: NULL))
510: INTO P_projfunc_cost_rate_date
511: FROM pa_projects_all proj,
512: pa_tasks task,
513: pa_implementations_all imp -- bug 8265941 changed to pa_implementations_all
514: WHERE task.task_id = P_task_id
515: AND proj.project_id = task.project_id
516: AND NVL(proj.org_id,-99) = NVL(imp.org_id,-99); -- bug 7579126
522: 'E', P_EI_date, 'P',
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
532: *********************/
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;
1426: FROM PA_Expenditure_Items ITEM,
1427: PA_Expenditures EXP,
1428: PA_Transaction_Sources TXN /* Bug 1824407 */
1429: /** To be uncommented after decing upon rates-model.
1430: ** CBGA Join pa_tasks with pa_expenditure_items_all.
1431: ** PA_Tasks TASK
1432: **/
1433: WHERE ITEM.Cost_Distributed_Flag = 'S'
1434: AND ITEM.Cost_Dist_Rejection_Code IS NULL
1427: PA_Expenditures EXP,
1428: PA_Transaction_Sources TXN /* Bug 1824407 */
1429: /** To be uncommented after decing upon rates-model.
1430: ** CBGA Join pa_tasks with pa_expenditure_items_all.
1431: ** PA_Tasks TASK
1432: **/
1433: WHERE ITEM.Cost_Distributed_Flag = 'S'
1434: AND ITEM.Cost_Dist_Rejection_Code IS NULL
1435: AND ITEM.Request_id = P_request_id
1440: OR
1441: ( ITEM.Source_Expenditure_Item_Id IS NOT NULL
1442: AND l_related_item = 'Y'))
1443: /** To be uncommented after decing upon rates-model.
1444: ** CBGA Joining pa_tasks with EIs.
1445: ** AND ITEM.task_id = TASK.task_id
1446: **/
1447: ;
1448: /******
2160: proj.project_rate_type), imp.default_rate_type))
2161: INTO P_project_currency_code,
2162: P_project_rate_type
2163: FROM pa_projects_all proj,
2164: pa_tasks task,
2165: pa_implementations_all imp
2166: WHERE proj.project_id = task.project_id
2167: AND task.task_id = P_task_id
2168: AND proj.org_id = imp.org_id;
2176: proj.project_rate_type), imp.default_rate_type))
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
2247: pa_utils2.get_pa_date(P_EI_date,
2248: sysdate, imp.org_id))) /**CBGA**/
2249: INTO P_project_rate_date
2250: FROM pa_projects_all proj,
2251: pa_tasks task,
2252: pa_implementations_all imp
2253: WHERE task.task_id = P_task_id
2254: AND proj.project_id = task.project_id
2255: AND nvl(proj.org_id, -99) = nvl(imp.org_id, -99);
2256: ELSE
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;