554: from dual
555: where exists
556: ( select 'Reverse in future period net-zero pair'
557: from pa_expenditure_items_all ei,
558: pa_cost_distribution_lines_all cdl,
559: pa_cost_distribution_lines_all reversal_cdl,
560: -- Start Changes for bug 15892024
561: pa_expenditures_all exp,
562: pa_expenditure_groups_all exp_grp
555: where exists
556: ( select 'Reverse in future period net-zero pair'
557: from pa_expenditure_items_all ei,
558: pa_cost_distribution_lines_all cdl,
559: pa_cost_distribution_lines_all reversal_cdl,
560: -- Start Changes for bug 15892024
561: pa_expenditures_all exp,
562: pa_expenditure_groups_all exp_grp
563: -- End Changes for bug 15892024
585: from dual
586: where exists
587: ( select 'Reverse in future period net-zero pair'
588: from pa_expenditure_items_all parent_ei,
589: pa_cost_distribution_lines_all cdl,
590: pa_cost_distribution_lines_all parent_cdl,
591: -- Start Changes for bug 15892024
592: pa_expenditures_all exp,
593: pa_expenditure_groups_all exp_grp
586: where exists
587: ( select 'Reverse in future period net-zero pair'
588: from pa_expenditure_items_all parent_ei,
589: pa_cost_distribution_lines_all cdl,
590: pa_cost_distribution_lines_all parent_cdl,
591: -- Start Changes for bug 15892024
592: pa_expenditures_all exp,
593: pa_expenditure_groups_all exp_grp
594: -- End Changes for bug 15892024