[Home] [Help]
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
4440: PA_PROJECT_UTILS.Check_prj_stus_action_allowed(ppr.project_status_code,
4441: 'CAPITALIZE') = 'Y' and
4442: ppr.project_type = pt.project_type and
4443: pt.project_type_class_code = 'CAPITAL'
4444: AND NOT EXISTS (SELECT 'X' /* Modified the selprjs cursor for Bug 7128863 start */
4992: pa_project_asset_lines pal
4993: WHERE
4994: ppr.segment1 between x_project_num_from and x_project_num_to and
4995: ppr.template_flag <> 'Y' and
4996: PA_PROJECT_UTILS.Check_prj_stus_action_allowed(ppr.project_status_code,
4997: 'CAPITALIZE') = 'Y' and
4998: ppr.project_type = pt.project_type and
4999: pt.project_type_class_code = 'CAPITAL' and
5000: pt.interface_asset_cost_code = 'F' and
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
5225: PA_PROJECT_UTILS.Check_prj_stus_action_allowed(ppr.project_status_code,
5226: 'CAPITALIZE') = 'Y' and
5227: ppr.project_type = pt.project_type and
5228: pt.project_type_class_code = 'CAPITAL' and
5229: pt.interface_asset_cost_code = 'F';
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'
5994: AND PA_PROJECT_UTILS.Check_prj_stus_action_allowed(p.project_status_code,'CAPITALIZE') = 'Y'
5995: AND p.project_type = pt.project_type
5996: AND pt.project_type_class_code = 'CAPITAL'
5997: AND NVL(p.capital_event_processing,'N') = 'N';
5998: