eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ROLLUP_RBVS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 45


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 59


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 73


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 88


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 103


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 118


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 133


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 149


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 163


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 177


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 192


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 207


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 222


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 237


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 252


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 267


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 282


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 297


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 312


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 327


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 342


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 357


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 372


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 387


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 404


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 421


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 436


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 451


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 466


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 481


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 496


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 511


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 526


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 541


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 556


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 571


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 586


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 601


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 616


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 631


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 646


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 661


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 676


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 691


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 706


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 721


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 736


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 751


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 766


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 781


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 796


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 811


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 826


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 841


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 857


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 877


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 897


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 915


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 933


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 951


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 969


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 987


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1001


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1016


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1031


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1047


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1067


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1087


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1101


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 1116


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 1131


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 1146


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 1161


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 1176


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1192


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 1208


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 1224


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 1240


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 1256


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 1272


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 1288


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 1304


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 1320


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1336


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1350


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1365


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1379


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1393


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1408


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1423


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1437


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 1453


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1467


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1481


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1496


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1511


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1526


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1541


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1556


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1571


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1586


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1600


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1614


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1629


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1644


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1659


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1674


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1688


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1703


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1718


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1733


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1748


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1763


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1778


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1793


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1808


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1823


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1838


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1853


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1868


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1883


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1898


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1913


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1928


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1943


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1958


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1973


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 1988


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 2003


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 2017


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 2033


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 2048


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 2063


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 2079


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(rbv.object_version_number,0)),0) sum_ovn ';

Line: 2097


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 2112


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 2127


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 2142


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 2157


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 2172


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 2187


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 2202


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 2216


  l_rawrt_selstr_va(l_rawrt_en)   := ' select count(*), '
                                   ||'     nvl(sum(nvl(object_version_number,0)),0) sum_ovn ';

Line: 2350


  l_sel_str := ' select count(*), '
               ||'  nvl(sum(nvl(object_version_number,0)),0) sum_ovn '
               ||', null min_esd '
               ||', null min_eed ';

Line: 2370


  l_sel_str := ' select count(*), '
               ||'  nvl(sum(nvl(object_version_number,0)),0) sum_ovn '
               ||', null min_esd '
               ||', null min_eed ';

Line: 2390


  l_sel_str := ' select count(*), '
               ||'  nvl(sum(nvl(object_version_number,0)),0) sum_ovn '
               ||', null min_esd '
               ||', null min_eed ';

Line: 2418


                               ||' and bbr.last_update_login = ccr.last_update_login '
                               ||' and ccr.status_code = '||''''||'R'||'''';

Line: 2421


  l_sel_str := ' select count(*), '
               ||'  nvl(sum(nvl(object_version_number,0)),0) sum_ovn '
               ||', null min_esd '
               ||', null min_eed ';

Line: 2442


  l_sel_str := ' select count(*), '
               ||'  nvl(sum(nvl(object_version_number,0)),0) sum_ovn '
               ||', null min_esd '
               ||', null min_eed ';

Line: 2460


  l_rt_wherestr_va(l_rt_en) := ' where abg.last_update_date < '
                               ||' (select bft.last_update_date '
                               ||' from ben_benefit_actions bft '
                               ||' where bft.benefit_action_id = :benefit_action_id) ';

Line: 2465


  l_sel_str := ' select count(*) '
               ||', 0 sum_ovn '
               ||', null min_esd '
               ||', null min_eed ';

Line: 2483


  l_rt_wherestr_va(l_rt_en) := ' where abg.last_update_date < '
                               ||' (select bft.last_update_date '
                               ||' from ben_benefit_actions bft '
                               ||' where bft.benefit_action_id = :benefit_action_id) '
                               ||' and abg.APPLICATION_SHORT_NAME = '||''''||'BEN'||'''';

Line: 2502


  l_rt_wherestr_va(l_rt_en) := ' where abg.last_update_date < '
                               ||' (select bft.last_update_date '
                               ||' from ben_benefit_actions bft '
                               ||' where bft.benefit_action_id = :benefit_action_id) '
                               ||' and abg.APPLICATION_SHORT_NAME = '||''''||'PER'||'''';

Line: 2521


  l_rt_wherestr_va(l_rt_en) := ' where abg.last_update_date < '
                               ||' (select bft.last_update_date '
                               ||' from ben_benefit_actions bft '
                               ||' where bft.benefit_action_id = :benefit_action_id) '
                               ||' and abg.APPLICATION_SHORT_NAME = '||''''||'PAY'||'''';

Line: 2651


      l_sel_str     := ' select pact.person_id, count(*) cnt ';

Line: 2671


      l_sel_str     := 'select pact.person_id, count(*) cnt ';

Line: 2965


  l_old_perid_va.delete;

Line: 2966


  l_old_cnt_va.delete;

Line: 2967


  l_old_combid_va.delete;

Line: 2968


  l_old_combid2_va.delete;

Line: 2969


  l_old_combid3_va.delete;

Line: 2970


  l_old_combid4_va.delete;

Line: 2971


  l_new_perid_va.delete;

Line: 2972


  l_new_cnt_va.delete;

Line: 2973


  l_new_combid_va.delete;

Line: 2974


  l_new_combid2_va.delete;

Line: 2975


  l_new_combid3_va.delete;

Line: 2976


  l_new_combid4_va.delete;

Line: 3325


      l_sel_str     := ' select pact.person_id, count(*) cnt ';

Line: 3347


      l_sel_str     := 'select pact.person_id '||l_keycol_str||', count(*) cnt ';

Line: 3435


        l_sel_str     := 'select pact.person_id '||l_keycol_str||', count(*) cnt ';

Line: 3505


    l_mmperid_va.delete;

Line: 3506


    l_mmcombid_va.delete;

Line: 3507


    l_mmcombid2_va.delete;

Line: 3508


    l_mmcombid3_va.delete;

Line: 3509


    l_mmcombid4_va.delete;

Line: 3510


    l_mmcnt_va.delete;

Line: 3786


      l_mmcombnm_va.delete;

Line: 3787


      l_mmcombnm2_va.delete;

Line: 3788


      l_mmcombnm3_va.delete;

Line: 3789


      l_mmcombnm4_va.delete;

Line: 3857


        l_sel_str     := ' select max(rbv.last_update_date) ';

Line: 3903


        l_sel_str     := ' select max(ppl.last_update_date) ';

Line: 3906


                         ||' and ppl.last_update_date < sysdate ';

Line: 4026


    select bft.validate_flag
    from ben_benefit_actions bft
    where bft.validate_flag in ('C','B')
    and bft.benefit_action_id = c_bft_id;

Line: 4037


    select bat.batch_id
    from ben_batch_actions bat
    where bat.batch_id = c_bft_id;

Line: 4080


      delete from ben_rollup_rbv_summary rlp
      where exists
        (select 1
         from ben_batch_actions bba
         where bba.batch_action_id = rlp.batch_action_id
         and bba.batch_id = p_benefit_action_id
        );

Line: 4088


      delete from ben_batch_actions bba
      where bba.batch_id = p_benefit_action_id;

Line: 4160


        l_sel_str := ' select PGM_ID||PTIP_ID||PLIP_ID||PL_ID||MUST_ENRL_ANTHR_PL_ID id_str, '
                     ||' null date_str, '
                     ||' null value_str ';

Line: 4229


      insert into ben_batch_actions
        (batch_action_id
        ,batch_id
        ,batch_type
        ,rollup_count
        ,rollup_sumovn
        )
      values
        (ben_batch_actions_s.nextval
        ,p_benefit_action_id
        ,'BEN_BFT'
        ,l_rollupcnt_tot
        ,l_rollupsumovn_tot
        ) RETURNING batch_action_id into l_batch_action_id;

Line: 4250


          insert into ben_rollup_rbv_summary
            (rollup_id
            ,batch_action_id
            ,rollup_code
            ,rollup_count
            ,rollup_sumovn
            ,rollup_minesd
            ,rollup_mineed
            ,rollup_id_string
            ,rollup_date_string
            ,rollup_value_string
            )
          values
            (ben_rollup_rbv_summary_s.nextval
            ,l_batch_action_id
            ,l_class_code_va(va_en)
            ,l_class_code_count_va(va_en)
            ,l_class_sumovn_va(va_en)
            ,l_class_minesd_va(va_en)
            ,l_class_mineed_va(va_en)
            ,l_class_idstr_va(va_en)
            ,l_class_datestr_va(va_en)
            ,l_class_valuestr_va(va_en)
            ) RETURNING rollup_id into l_rollup_id;