[Home] [Help]
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
4056: PA_PROJECT_UTILS.Check_prj_stus_action_allowed(ppr.project_status_code,
4057: 'CAPITALIZE') = 'Y' and
4058: ppr.project_type = pt.project_type and
4059: pt.project_type_class_code = 'CAPITAL'
4060: AND NOT EXISTS (SELECT 'X' /* Modified the selprjs cursor for Bug 7128863 start */
4606: pa_project_asset_lines pal
4607: WHERE
4608: ppr.segment1 between x_project_num_from and x_project_num_to and
4609: ppr.template_flag <> 'Y' and
4610: PA_PROJECT_UTILS.Check_prj_stus_action_allowed(ppr.project_status_code,
4611: 'CAPITALIZE') = 'Y' and
4612: ppr.project_type = pt.project_type and
4613: pt.project_type_class_code = 'CAPITAL' and
4614: pt.interface_asset_cost_code = 'F' and
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
4839: PA_PROJECT_UTILS.Check_prj_stus_action_allowed(ppr.project_status_code,
4840: 'CAPITALIZE') = 'Y' and
4841: ppr.project_type = pt.project_type and
4842: pt.project_type_class_code = 'CAPITAL' and
4843: pt.interface_asset_cost_code = 'F';
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'
5608: AND PA_PROJECT_UTILS.Check_prj_stus_action_allowed(p.project_status_code,'CAPITALIZE') = 'Y'
5609: AND p.project_type = pt.project_type
5610: AND pt.project_type_class_code = 'CAPITAL'
5611: AND NVL(p.capital_event_processing,'N') = 'N';
5612: