[Home] [Help]
1954: /* Added for bug 6788325 */
1955:
1956: SELECT pt.capital_cost_type_code
1957: INTO l_amount_type
1958: FROM pa_projects ppr,
1959: pa_project_types pt
1960: WHERE ppr.project_type=pt.project_type
1961: AND project_id=x_project_id;
1962:
3332: ppa.tag_number
3333: FROM
3334: pa_project_asset_lines pal,
3335: pa_project_assets ppa,
3336: pa_projects pp,
3337: pa_project_types ppt
3338: WHERE
3339: pal.project_asset_id = ppa.project_asset_id
3340: AND ppa.project_id = pp.project_id
4047: 'D','N',
4048: 'Y')) total_burden_flag,
4049: pt.Burden_amt_display_method
4050: FROM
4051: pa_projects ppr,
4052: pa_project_types pt
4053: WHERE
4054: ppr.segment1 between x_project_num_from and x_project_num_to and
4055: ppr.template_flag <> 'Y' and
4108: pce.event_name,
4109: NVL(pce.asset_allocation_method, NVL(p.asset_allocation_method,'N')) asset_allocation_method,
4110: pal.asset_category_id /* Added for bug#3211946 */
4111: FROM pa_project_asset_lines_all pal,
4112: pa_projects p,
4113: pa_capital_events pce
4114: WHERE pal.project_id = p.project_id
4115: AND p.project_id = x_project_id
4116: AND pal.capital_event_id = NVL(x_capital_event_id, pal.capital_event_id)
4600: SELECT distinct
4601: ppr.project_id,
4602: ppr.segment1
4603: FROM
4604: pa_projects ppr,
4605: pa_project_types pt,
4606: pa_project_asset_lines pal
4607: WHERE
4608: ppr.segment1 between x_project_num_from and x_project_num_to and
4830: CURSOR selprjs IS
4831: SELECT
4832: ppr.project_id
4833: FROM
4834: pa_projects ppr,
4835: pa_project_types pt
4836: WHERE
4837: ppr.segment1 between x_project_num_from and x_project_num_to and
4838: ppr.template_flag <> 'Y' and
4993: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
4994: FROM pa_cost_distribution_lines_all pcdl,
4995: pa_expenditure_items_all pei,
4996: pa_tasks pat,
4997: pa_projects pp,
4998: pa_project_types pt
4999: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5000: AND pp.project_id = p_project_id
5001: AND pp.project_type = pt.project_type
5081: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized Retirement Cost expenditure items
5082: FROM pa_cost_distribution_lines_all pcdl,
5083: pa_expenditure_items_all pei,
5084: pa_tasks pat,
5085: pa_projects pp,
5086: pa_project_types pt
5087: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5088: AND pp.project_id = p_project_id
5089: AND pp.project_type = pt.project_type
5132: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
5133: FROM pa_cost_distribution_lines_all pcdl,
5134: pa_expenditure_items_all pei,
5135: --pa_tasks pat, /* bug fix :2830211 task_id is not reqd */
5136: pa_projects_all pp,
5137: pa_project_types pt
5138: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5139: AND pp.project_id = p_project_id
5140: AND pei.project_id = pp.project_id /* added for bug fix :2830211 */
5330: pal.gl_date
5331: FROM
5332: pa_project_asset_lines pal,
5333: pa_project_assets ppa,
5334: pa_projects pp,
5335: pa_project_types ppt
5336: WHERE
5337: pal.project_asset_id = ppa.project_asset_id
5338: AND ppa.project_id = pp.project_id
5599:
5600: /* Commented for bug 5758490
5601: CURSOR no_event_proj_cur IS
5602: SELECT p.project_id
5603: FROM pa_projects p,
5604: pa_project_types pt
5605: WHERE p.segment1
5606: BETWEEN x_project_num_from AND x_project_num_to
5607: AND p.template_flag <> 'Y'
5629: FOR no_event_proj_rec IN no_event_proj_cur LOOP */
5630:
5631: begin
5632: select 'Y' into is_no_event_proj
5633: from pa_projects_all p
5634: where p.project_id = x_project_id
5635: and NVL(p.capital_event_processing,'N') = 'N';
5636: exception -- Added exception handling for bug 5909337
5637: when no_data_found then
5895:
5896: SELECT p_type.capital_cost_type_code
5897: INTO l_capital_cost_type
5898: FROM pa_project_types_all p_type,
5899: pa_projects_all proj,
5900: pa_cost_distribution_lines_all pa_cdl
5901: WHERE p_type.project_type = proj.project_type
5902: AND proj.project_id = pa_cdl.project_id
5903: AND pa_cdl.expenditure_item_id = x_expenditure_item_id