[Home] [Help]
2201: /* Added for bug 6788325 */
2202:
2203: SELECT pt.capital_cost_type_code
2204: INTO l_amount_type
2205: FROM pa_projects ppr,
2206: pa_project_types pt
2207: WHERE ppr.project_type=pt.project_type
2208: AND project_id=x_project_id;
2209:
3700: ppa.tag_number
3701: FROM
3702: pa_project_asset_lines pal,
3703: pa_project_assets ppa,
3704: pa_projects pp,
3705: pa_project_types ppt
3706: WHERE
3707: pal.project_asset_id = ppa.project_asset_id
3708: AND ppa.project_id = pp.project_id
4431: 'D','N',
4432: 'Y')) total_burden_flag,
4433: pt.Burden_amt_display_method
4434: FROM
4435: pa_projects ppr,
4436: pa_project_types pt
4437: WHERE
4438: ppr.segment1 between x_project_num_from and x_project_num_to and
4439: ppr.template_flag <> 'Y' and
4492: pce.event_name,
4493: NVL(pce.asset_allocation_method, NVL(p.asset_allocation_method,'N')) asset_allocation_method,
4494: pal.asset_category_id /* Added for bug#3211946 */
4495: FROM pa_project_asset_lines_all pal,
4496: pa_projects p,
4497: pa_capital_events pce
4498: WHERE pal.project_id = p.project_id
4499: AND p.project_id = x_project_id
4500: AND pal.capital_event_id = NVL(x_capital_event_id, pal.capital_event_id)
4986: SELECT distinct
4987: ppr.project_id,
4988: ppr.segment1
4989: FROM
4990: pa_projects ppr,
4991: pa_project_types pt,
4992: pa_project_asset_lines pal
4993: WHERE
4994: ppr.segment1 between x_project_num_from and x_project_num_to and
5216: CURSOR selprjs IS
5217: SELECT
5218: ppr.project_id
5219: FROM
5220: pa_projects ppr,
5221: pa_project_types pt
5222: WHERE
5223: ppr.segment1 between x_project_num_from and x_project_num_to and
5224: ppr.template_flag <> 'Y' and
5379: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
5380: FROM pa_cost_distribution_lines_all pcdl,
5381: pa_expenditure_items_all pei,
5382: pa_tasks pat,
5383: pa_projects pp,
5384: pa_project_types pt
5385: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5386: AND pp.project_id = p_project_id
5387: AND pp.project_type = pt.project_type
5467: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized Retirement Cost expenditure items
5468: FROM pa_cost_distribution_lines_all pcdl,
5469: pa_expenditure_items_all pei,
5470: pa_tasks pat,
5471: pa_projects pp,
5472: pa_project_types pt
5473: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5474: AND pp.project_id = p_project_id
5475: AND pp.project_type = pt.project_type
5518: WHERE EXISTS (SELECT 'x' -- project has costed,uncapitalized expenditure items
5519: FROM pa_cost_distribution_lines_all pcdl,
5520: pa_expenditure_items_all pei,
5521: --pa_tasks pat, /* bug fix :2830211 task_id is not reqd */
5522: pa_projects_all pp,
5523: pa_project_types pt
5524: WHERE pcdl.expenditure_item_id = pei.expenditure_item_id
5525: AND pp.project_id = p_project_id
5526: AND pei.project_id = pp.project_id /* added for bug fix :2830211 */
5716: pal.gl_date
5717: FROM
5718: pa_project_asset_lines pal,
5719: pa_project_assets ppa,
5720: pa_projects pp,
5721: pa_project_types ppt
5722: WHERE
5723: pal.project_asset_id = ppa.project_asset_id
5724: AND ppa.project_id = pp.project_id
5985:
5986: /* Commented for bug 5758490
5987: CURSOR no_event_proj_cur IS
5988: SELECT p.project_id
5989: FROM pa_projects p,
5990: pa_project_types pt
5991: WHERE p.segment1
5992: BETWEEN x_project_num_from AND x_project_num_to
5993: AND p.template_flag <> 'Y'
6015: FOR no_event_proj_rec IN no_event_proj_cur LOOP */
6016:
6017: begin
6018: select 'Y' into is_no_event_proj
6019: from pa_projects_all p
6020: where p.project_id = x_project_id
6021: and NVL(p.capital_event_processing,'N') = 'N';
6022: exception -- Added exception handling for bug 5909337
6023: when no_data_found then
6341:
6342: SELECT p_type.capital_cost_type_code
6343: INTO l_capital_cost_type
6344: FROM pa_project_types_all p_type,
6345: pa_projects_all proj,
6346: pa_cost_distribution_lines_all pa_cdl
6347: WHERE p_type.project_type = proj.project_type
6348: AND proj.project_id = pa_cdl.project_id
6349: AND pa_cdl.expenditure_item_id = x_expenditure_item_id