[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;
1433: FROM PA_Expenditure_Items ITEM,
1434: PA_Expenditures EXP,
1435: PA_Transaction_Sources TXN /* Bug 1824407 */
1436: /** To be uncommented after decing upon rates-model.
1437: ** CBGA Join pa_tasks with pa_expenditure_items_all.
1438: ** PA_Tasks TASK
1439: **/
1440: WHERE ITEM.Cost_Distributed_Flag = 'S'
1441: AND ITEM.Cost_Dist_Rejection_Code IS NULL
1434: PA_Expenditures EXP,
1435: PA_Transaction_Sources TXN /* Bug 1824407 */
1436: /** To be uncommented after decing upon rates-model.
1437: ** CBGA Join pa_tasks with pa_expenditure_items_all.
1438: ** PA_Tasks TASK
1439: **/
1440: WHERE ITEM.Cost_Distributed_Flag = 'S'
1441: AND ITEM.Cost_Dist_Rejection_Code IS NULL
1442: AND ITEM.Request_id = P_request_id
1447: OR
1448: ( ITEM.Source_Expenditure_Item_Id IS NOT NULL
1449: AND l_related_item = 'Y'))
1450: /** To be uncommented after decing upon rates-model.
1451: ** CBGA Joining pa_tasks with EIs.
1452: ** AND ITEM.task_id = TASK.task_id
1453: **/
1454: ;
1455: /******
2249: proj.project_rate_type), imp.default_rate_type))
2250: INTO P_project_currency_code,
2251: P_project_rate_type
2252: FROM pa_projects_all proj,
2253: pa_tasks task,
2254: pa_implementations_all imp
2255: WHERE proj.project_id = task.project_id
2256: AND task.task_id = P_task_id
2257: AND proj.org_id = imp.org_id;
2265: proj.project_rate_type), imp.default_rate_type))
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
2336: pa_utils2.get_pa_date(P_EI_date,
2337: sysdate, imp.org_id))) /**CBGA**/
2338: INTO P_project_rate_date
2339: FROM pa_projects_all proj,
2340: pa_tasks task,
2341: pa_implementations_all imp
2342: WHERE task.task_id = P_task_id
2343: AND proj.project_id = task.project_id
2344: AND nvl(proj.org_id, -99) = nvl(imp.org_id, -99);
2345: ELSE
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;