655:
656: hr_utility.set_location(l_package||l_procedure,30);
657: -- set the session variable as we are only getting the
658: -- RUN Balance
659: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
660: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
661: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
662: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
663: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
656: hr_utility.set_location(l_package||l_procedure,30);
657: -- set the session variable as we are only getting the
658: -- RUN Balance
659: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
660: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
661: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
662: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
663: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
664:
657: -- set the session variable as we are only getting the
658: -- RUN Balance
659: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
660: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
661: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
662: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
663: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
664:
665: -- For all the run actions locked by prepayment , get all the
658: -- RUN Balance
659: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
660: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
661: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
662: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
663: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
664:
665: -- For all the run actions locked by prepayment , get all the
666: -- earnings elements and corresponding run value
659: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
660: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
661: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
662: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
663: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
664:
665: -- For all the run actions locked by prepayment , get all the
666: -- earnings elements and corresponding run value
667: FOR i IN run_actions_tab.FIRST .. run_actions_tab.LAST LOOP
721: IF master_actions_tab.count > 0 then
722:
723: hr_utility.set_location(l_package||l_procedure,90);
724:
725: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
726: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
727: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
728: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
729: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
722:
723: hr_utility.set_location(l_package||l_procedure,90);
724:
725: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
726: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
727: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
728: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
729: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
730:
723: hr_utility.set_location(l_package||l_procedure,90);
724:
725: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
726: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
727: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
728: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
729: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
730:
731: FOR i IN master_actions_tab.FIRST .. master_actions_tab.LAST LOOP
724:
725: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
726: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
727: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
728: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
729: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
730:
731: FOR i IN master_actions_tab.FIRST .. master_actions_tab.LAST LOOP
732: IF master_actions_tab.exists(i) THEN
725: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
726: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
727: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
728: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
729: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
730:
731: FOR i IN master_actions_tab.FIRST .. master_actions_tab.LAST LOOP
732: IF master_actions_tab.exists(i) THEN
733: OPEN c_get_pre_earn_ytd_rb(master_actions_tab(i).aaid);
797:
798: hr_utility.set_location(l_package||l_procedure,120);
799:
800: IF run_actions_tab.COUNT >0 THEN
801: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
802: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
803: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
804: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
805: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
798: hr_utility.set_location(l_package||l_procedure,120);
799:
800: IF run_actions_tab.COUNT >0 THEN
801: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
802: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
803: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
804: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
805: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
806:
799:
800: IF run_actions_tab.COUNT >0 THEN
801: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
802: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
803: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
804: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
805: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
806:
807: -- For all the run actions locked by prepayment , get all the
800: IF run_actions_tab.COUNT >0 THEN
801: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
802: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
803: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
804: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
805: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
806:
807: -- For all the run actions locked by prepayment , get all the
808: -- earnings elements and corresponding run value
801: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
802: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
803: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
804: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
805: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
806:
807: -- For all the run actions locked by prepayment , get all the
808: -- earnings elements and corresponding run value
809: FOR i IN run_actions_tab.FIRST .. run_actions_tab.LAST LOOP
900: hr_utility.set_location(l_package||l_procedure,226);
901: IF earnings_elements_tab.COUNT > 0 THEN
902:
903: IF master_actions_tab.COUNT>0 THEN
904: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
905: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
906: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
907: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
908: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
901: IF earnings_elements_tab.COUNT > 0 THEN
902:
903: IF master_actions_tab.COUNT>0 THEN
904: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
905: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
906: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
907: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
908: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
909:
902:
903: IF master_actions_tab.COUNT>0 THEN
904: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
905: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
906: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
907: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
908: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
909:
910: FOR i IN master_actions_tab.FIRST .. master_actions_tab.LAST LOOP
903: IF master_actions_tab.COUNT>0 THEN
904: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
905: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
906: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
907: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
908: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
909:
910: FOR i IN master_actions_tab.FIRST .. master_actions_tab.LAST LOOP
911: IF master_actions_tab.exists(i) THEN
904: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
905: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
906: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
907: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
908: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
909:
910: FOR i IN master_actions_tab.FIRST .. master_actions_tab.LAST LOOP
911: IF master_actions_tab.exists(i) THEN
912:
950:
951: IF p_balance_status = 'Y' THEN
952:
953: hr_utility.set_location(l_package||l_procedure,160);
954: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
955: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
956: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
957: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
958: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
951: IF p_balance_status = 'Y' THEN
952:
953: hr_utility.set_location(l_package||l_procedure,160);
954: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
955: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
956: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
957: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
958: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
959: earnings_elements_tab.delete;
952:
953: hr_utility.set_location(l_package||l_procedure,160);
954: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
955: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
956: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
957: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
958: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
959: earnings_elements_tab.delete;
960: p_earn_tab.delete;
953: hr_utility.set_location(l_package||l_procedure,160);
954: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
955: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
956: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
957: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
958: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
959: earnings_elements_tab.delete;
960: p_earn_tab.delete;
961:
954: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
955: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
956: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
957: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
958: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
959: earnings_elements_tab.delete;
960: p_earn_tab.delete;
961:
962: OPEN c_get_pay_rb_elements(p_assignment_action_id);
1395: IF run_actions_tab.COUNT>0 THEN
1396: start_cnt := run_actions_tab.FIRST;
1397: end_cnt := run_actions_tab.LAST;
1398: j := 0;
1399: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1400: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1401: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1402: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1403: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1396: start_cnt := run_actions_tab.FIRST;
1397: end_cnt := run_actions_tab.LAST;
1398: j := 0;
1399: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1400: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1401: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1402: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1403: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1404:
1397: end_cnt := run_actions_tab.LAST;
1398: j := 0;
1399: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1400: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1401: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1402: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1403: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1404:
1405: hr_utility.set_location(l_package||l_procedure,40);
1398: j := 0;
1399: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1400: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1401: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1402: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1403: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1404:
1405: hr_utility.set_location(l_package||l_procedure,40);
1406: FOR i IN start_cnt..end_cnt LOOP
1399: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1400: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1401: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1402: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1403: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1404:
1405: hr_utility.set_location(l_package||l_procedure,40);
1406: FOR i IN start_cnt..end_cnt LOOP
1407: IF run_actions_tab.exists(i) THEN
1440: IF master_actions_tab.COUNT>0 THEN
1441: start_cnt:=master_actions_tab.FIRST;
1442: end_cnt:=master_actions_tab.LAST;
1443:
1444: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1445: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1446: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1447: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1448: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1441: start_cnt:=master_actions_tab.FIRST;
1442: end_cnt:=master_actions_tab.LAST;
1443:
1444: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1445: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1446: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1447: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1448: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1449:
1442: end_cnt:=master_actions_tab.LAST;
1443:
1444: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1445: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1446: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1447: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1448: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1449:
1450: hr_utility.set_location(l_package||l_procedure,100);
1443:
1444: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1445: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1446: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1447: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1448: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1449:
1450: hr_utility.set_location(l_package||l_procedure,100);
1451: FOR i IN start_cnt..end_cnt LOOP
1444: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1445: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1446: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1447: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1448: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1449:
1450: hr_utility.set_location(l_package||l_procedure,100);
1451: FOR i IN start_cnt..end_cnt LOOP
1452: IF master_actions_tab.exists(i) THEN
1481: IF run_actions_tab.count>0 THEN
1482: start_cnt := run_actions_tab.FIRST;
1483: end_cnt := run_actions_tab.LAST;
1484:
1485: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1486: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1487: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1488: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1489: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1482: start_cnt := run_actions_tab.FIRST;
1483: end_cnt := run_actions_tab.LAST;
1484:
1485: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1486: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1487: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1488: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1489: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1490:
1483: end_cnt := run_actions_tab.LAST;
1484:
1485: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1486: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1487: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1488: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1489: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1490:
1491: FOR i IN start_cnt..end_cnt LOOP
1484:
1485: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1486: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1487: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1488: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1489: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1490:
1491: FOR i IN start_cnt..end_cnt LOOP
1492: OPEN c_get_pre_fed_run_rr(run_actions_tab(i).aaid);
1485: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1486: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1487: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1488: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1489: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1490:
1491: FOR i IN start_cnt..end_cnt LOOP
1492: OPEN c_get_pre_fed_run_rr(run_actions_tab(i).aaid);
1493:
1525: start_cnt:= master_actions_tab.FIRST;
1526: end_cnt:=master_actions_tab.LAST;
1527:
1528: hr_utility.set_location(l_package||l_procedure,170);
1529: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1530: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1531: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1532: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1533: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1526: end_cnt:=master_actions_tab.LAST;
1527:
1528: hr_utility.set_location(l_package||l_procedure,170);
1529: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1530: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1531: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1532: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1533: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1534:
1527:
1528: hr_utility.set_location(l_package||l_procedure,170);
1529: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1530: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1531: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1532: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1533: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1534:
1535: FOR i IN start_cnt..end_cnt LOOP
1528: hr_utility.set_location(l_package||l_procedure,170);
1529: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1530: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1531: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1532: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1533: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1534:
1535: FOR i IN start_cnt..end_cnt LOOP
1536: IF master_actions_tab.exists(i) THEN
1529: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1530: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1531: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1532: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1533: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1534:
1535: FOR i IN start_cnt..end_cnt LOOP
1536: IF master_actions_tab.exists(i) THEN
1537: OPEN c_get_pre_fed_ytd_rr(master_actions_tab(i).aaid);
1564:
1565: ELSE
1566:
1567: hr_utility.set_location(l_package||l_procedure,210);
1568: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1569: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1570: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1571: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1572: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1565: ELSE
1566:
1567: hr_utility.set_location(l_package||l_procedure,210);
1568: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1569: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1570: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1571: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1572: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1573:
1566:
1567: hr_utility.set_location(l_package||l_procedure,210);
1568: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1569: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1570: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1571: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1572: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1573:
1574: hr_utility.set_location(l_package||l_procedure,220);
1567: hr_utility.set_location(l_package||l_procedure,210);
1568: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1569: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1570: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1571: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1572: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1573:
1574: hr_utility.set_location(l_package||l_procedure,220);
1575: -------------Run Federal Taxes Start-------------------------------
1568: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1569: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1570: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1571: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1572: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1573:
1574: hr_utility.set_location(l_package||l_procedure,220);
1575: -------------Run Federal Taxes Start-------------------------------
1576: i := 0;
1850:
1851: start_cnt := run_actions_tab.FIRST;
1852: end_cnt := run_actions_tab.LAST;
1853:
1854: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1855: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1856: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1857: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1858: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1851: start_cnt := run_actions_tab.FIRST;
1852: end_cnt := run_actions_tab.LAST;
1853:
1854: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1855: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1856: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1857: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1858: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1859:
1852: end_cnt := run_actions_tab.LAST;
1853:
1854: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1855: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1856: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1857: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1858: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1859:
1860: hr_utility.set_location(l_package||l_procedure,30);
1853:
1854: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1855: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1856: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1857: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1858: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1859:
1860: hr_utility.set_location(l_package||l_procedure,30);
1861:
1854: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1855: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1856: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1857: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1858: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1859:
1860: hr_utility.set_location(l_package||l_procedure,30);
1861:
1862: FOR i IN start_cnt..end_cnt LOOP
1896: IF master_actions_tab.COUNT>0 THEN
1897: start_cnt:=master_actions_tab.FIRST;
1898: end_cnt:=master_actions_tab.LAST;
1899:
1900: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1901: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1902: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1903: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1904: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1897: start_cnt:=master_actions_tab.FIRST;
1898: end_cnt:=master_actions_tab.LAST;
1899:
1900: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1901: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1902: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1903: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1904: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1905:
1898: end_cnt:=master_actions_tab.LAST;
1899:
1900: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1901: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1902: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1903: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1904: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1905:
1906: hr_utility.set_location(l_package||l_procedure,70);
1899:
1900: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1901: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1902: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1903: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1904: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1905:
1906: hr_utility.set_location(l_package||l_procedure,70);
1907: FOR i IN start_cnt..end_cnt LOOP
1900: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1901: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1902: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1903: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1904: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1905:
1906: hr_utility.set_location(l_package||l_procedure,70);
1907: FOR i IN start_cnt..end_cnt LOOP
1908: IF master_actions_tab.exists(i) THEN
1938: IF run_actions_tab.COUNT>0 THEN
1939: start_cnt := run_actions_tab.FIRST;
1940: end_cnt := run_actions_tab.LAST;
1941:
1942: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1943: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1944: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1945: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1946: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1939: start_cnt := run_actions_tab.FIRST;
1940: end_cnt := run_actions_tab.LAST;
1941:
1942: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1943: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1944: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1945: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1946: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1947:
1940: end_cnt := run_actions_tab.LAST;
1941:
1942: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1943: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1944: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1945: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1946: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1947:
1948: FOR i IN start_cnt..end_cnt LOOP
1941:
1942: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1943: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1944: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1945: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1946: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1947:
1948: FOR i IN start_cnt..end_cnt LOOP
1949: IF run_actions_tab.exists(i) THEN
1942: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
1943: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1944: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1945: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1946: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
1947:
1948: FOR i IN start_cnt..end_cnt LOOP
1949: IF run_actions_tab.exists(i) THEN
1950: OPEN c_get_pre_state_run_rr(run_actions_tab(i).aaid);
1983: IF master_actions_tab.COUNT>0 THEN
1984: start_cnt:=master_actions_tab.FIRST;
1985: end_cnt:=master_actions_tab.LAST;
1986:
1987: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1988: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1989: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1990: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1991: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1984: start_cnt:=master_actions_tab.FIRST;
1985: end_cnt:=master_actions_tab.LAST;
1986:
1987: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1988: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1989: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1990: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1991: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1992:
1985: end_cnt:=master_actions_tab.LAST;
1986:
1987: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1988: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1989: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1990: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1991: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1992:
1993: FOR i IN start_cnt..end_cnt LOOP
1986:
1987: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1988: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1989: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1990: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1991: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1992:
1993: FOR i IN start_cnt..end_cnt LOOP
1994: IF master_actions_tab.exists(i) THEN
1987: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
1988: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
1989: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
1990: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
1991: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1992:
1993: FOR i IN start_cnt..end_cnt LOOP
1994: IF master_actions_tab.exists(i) THEN
1995: OPEN c_get_pre_state_ytd_rr(master_actions_tab(i).aaid);
2029:
2030: ELSE -- SOE for Run Action
2031:
2032: hr_utility.set_location(l_package||l_procedure,160);
2033: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2034: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2035: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2036: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2037: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2030: ELSE -- SOE for Run Action
2031:
2032: hr_utility.set_location(l_package||l_procedure,160);
2033: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2034: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2035: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2036: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2037: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2038:
2031:
2032: hr_utility.set_location(l_package||l_procedure,160);
2033: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2034: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2035: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2036: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2037: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2038:
2039: -------------Start State Run--------------------------------------
2032: hr_utility.set_location(l_package||l_procedure,160);
2033: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2034: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2035: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2036: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2037: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2038:
2039: -------------Start State Run--------------------------------------
2040: --State taxes
2033: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2034: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2035: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2036: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2037: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2038:
2039: -------------Start State Run--------------------------------------
2040: --State taxes
2041: --Use run Balances
2330: IF run_actions_tab.COUNT>0 THEN
2331: start_cnt := run_actions_tab.FIRST;
2332: end_cnt := run_actions_tab.LAST;
2333:
2334: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2335: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2336: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2337: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2338: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2331: start_cnt := run_actions_tab.FIRST;
2332: end_cnt := run_actions_tab.LAST;
2333:
2334: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2335: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2336: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2337: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2338: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2339:
2332: end_cnt := run_actions_tab.LAST;
2333:
2334: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2335: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2336: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2337: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2338: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2339:
2340: FOR i IN start_cnt..end_cnt LOOP
2333:
2334: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2335: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2336: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2337: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2338: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2339:
2340: FOR i IN start_cnt..end_cnt LOOP
2341: IF run_actions_tab.exists(i) THEN
2334: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2335: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2336: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2337: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2338: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2339:
2340: FOR i IN start_cnt..end_cnt LOOP
2341: IF run_actions_tab.exists(i) THEN
2342: OPEN c_get_pre_local_run_rb(run_actions_tab(i).aaid);
2376: IF master_actions_tab.COUNT>0 THEN
2377: start_cnt:=master_actions_tab.FIRST;
2378: end_cnt:=master_actions_tab.LAST;
2379:
2380: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2381: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2382: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2383: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2384: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2377: start_cnt:=master_actions_tab.FIRST;
2378: end_cnt:=master_actions_tab.LAST;
2379:
2380: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2381: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2382: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2383: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2384: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2385:
2378: end_cnt:=master_actions_tab.LAST;
2379:
2380: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2381: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2382: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2383: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2384: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2385:
2386: hr_utility.set_location(l_package||l_procedure,60);
2379:
2380: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2381: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2382: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2383: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2384: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2385:
2386: hr_utility.set_location(l_package||l_procedure,60);
2387: FOR i IN start_cnt..end_cnt LOOP
2380: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2381: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2382: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2383: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2384: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2385:
2386: hr_utility.set_location(l_package||l_procedure,60);
2387: FOR i IN start_cnt..end_cnt LOOP
2388: IF master_actions_tab.exists(i) THEN
2419: IF run_actions_tab.COUNT>0 THEN
2420: start_cnt := run_actions_tab.FIRST;
2421: end_cnt := run_actions_tab.LAST;
2422:
2423: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2424: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2425: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2426: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2427: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2420: start_cnt := run_actions_tab.FIRST;
2421: end_cnt := run_actions_tab.LAST;
2422:
2423: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2424: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2425: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2426: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2427: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2428:
2421: end_cnt := run_actions_tab.LAST;
2422:
2423: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2424: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2425: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2426: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2427: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2428:
2429: FOR i IN start_cnt..end_cnt LOOP
2422:
2423: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2424: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2425: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2426: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2427: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2428:
2429: FOR i IN start_cnt..end_cnt LOOP
2430: IF run_actions_tab.exists(i)THEN
2423: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2424: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2425: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2426: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2427: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2428:
2429: FOR i IN start_cnt..end_cnt LOOP
2430: IF run_actions_tab.exists(i)THEN
2431: OPEN c_get_pre_local_run_rr(run_actions_tab(i).aaid);
2464: IF master_actions_tab.COUNT>0 THEN
2465: start_cnt := master_actions_tab.FIRST;
2466: end_cnt := master_actions_tab.LAST;
2467:
2468: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2469: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2470: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2471: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2472: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2465: start_cnt := master_actions_tab.FIRST;
2466: end_cnt := master_actions_tab.LAST;
2467:
2468: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2469: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2470: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2471: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2472: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2473:
2466: end_cnt := master_actions_tab.LAST;
2467:
2468: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2469: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2470: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2471: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2472: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2473:
2474: hr_utility.set_location(l_package||l_procedure,120);
2467:
2468: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2469: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2470: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2471: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2472: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2473:
2474: hr_utility.set_location(l_package||l_procedure,120);
2475: FOR i IN start_cnt..end_cnt LOOP
2468: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2469: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2470: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2471: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2472: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2473:
2474: hr_utility.set_location(l_package||l_procedure,120);
2475: FOR i IN start_cnt..end_cnt LOOP
2476: IF master_actions_tab.exists(i) THEN
2505:
2506: ELSE -- SOE for Run is viewed
2507:
2508: hr_utility.set_location(l_package||l_procedure,150);
2509: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2510: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2511: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2512: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2513: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2506: ELSE -- SOE for Run is viewed
2507:
2508: hr_utility.set_location(l_package||l_procedure,150);
2509: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2510: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2511: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2512: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2513: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2514:
2507:
2508: hr_utility.set_location(l_package||l_procedure,150);
2509: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2510: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2511: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2512: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2513: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2514:
2515: i := 0;
2508: hr_utility.set_location(l_package||l_procedure,150);
2509: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2510: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2511: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2512: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2513: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2514:
2515: i := 0;
2516:
2509: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2510: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2511: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2512: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2513: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2514:
2515: i := 0;
2516:
2517: ------- Start Local Taxes-------------------
2800:
2801: IF p_pre_balance_status = 'Y' and p_aft_balance_status = 'Y' THEN
2802:
2803: IF run_actions_tab.COUNT >0 THEN
2804: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2805: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2806: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2807: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2808: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2801: IF p_pre_balance_status = 'Y' and p_aft_balance_status = 'Y' THEN
2802:
2803: IF run_actions_tab.COUNT >0 THEN
2804: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2805: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2806: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2807: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2808: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2809:
2802:
2803: IF run_actions_tab.COUNT >0 THEN
2804: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2805: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2806: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2807: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2808: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2809:
2810: hr_utility.set_location(l_package||l_procedure,30);
2803: IF run_actions_tab.COUNT >0 THEN
2804: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2805: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2806: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2807: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2808: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2809:
2810: hr_utility.set_location(l_package||l_procedure,30);
2811: FOR i IN run_actions_tab.FIRST .. run_actions_tab.LAST LOOP
2804: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2805: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2806: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2807: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2808: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2809:
2810: hr_utility.set_location(l_package||l_procedure,30);
2811: FOR i IN run_actions_tab.FIRST .. run_actions_tab.LAST LOOP
2812: IF run_actions_tab.exists(i) THEN
2845: IF p_dedn_tab.COUNT > 0 THEN
2846: hr_utility.set_location(l_package||l_procedure,60);
2847: IF master_Actions_tab.COUNT>0 THEN
2848:
2849: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2850: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2851: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2852: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2853: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2846: hr_utility.set_location(l_package||l_procedure,60);
2847: IF master_Actions_tab.COUNT>0 THEN
2848:
2849: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2850: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2851: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2852: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2853: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2854:
2847: IF master_Actions_tab.COUNT>0 THEN
2848:
2849: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2850: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2851: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2852: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2853: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2854:
2855: FOR i IN master_actions_tab.FIRST .. master_actions_tab.LAST LOOP
2848:
2849: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2850: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2851: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2852: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2853: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2854:
2855: FOR i IN master_actions_tab.FIRST .. master_actions_tab.LAST LOOP
2856: IF master_actions_tab.exists(i) THEN
2849: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2850: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2851: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2852: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2853: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2854:
2855: FOR i IN master_actions_tab.FIRST .. master_actions_tab.LAST LOOP
2856: IF master_actions_tab.exists(i) THEN
2857: OPEN c_get_dedn_ytd_rb(master_actions_tab(i).aaid);
2898:
2899: hr_utility.set_location(l_package||l_procedure,80);
2900:
2901: IF run_actions_tab.COUNT>0 THEN
2902: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2903: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2904: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2905: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2906: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2899: hr_utility.set_location(l_package||l_procedure,80);
2900:
2901: IF run_actions_tab.COUNT>0 THEN
2902: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2903: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2904: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2905: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2906: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2907:
2900:
2901: IF run_actions_tab.COUNT>0 THEN
2902: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2903: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2904: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2905: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2906: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2907:
2908: FOR i IN run_actions_tab.FIRST .. run_actions_tab.LAST LOOP
2901: IF run_actions_tab.COUNT>0 THEN
2902: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2903: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2904: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2905: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2906: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2907:
2908: FOR i IN run_actions_tab.FIRST .. run_actions_tab.LAST LOOP
2909: IF run_actions_tab.exists(i) THEN
2902: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
2903: pay_us_balance_view_pkg.set_session_var('YTD','FALSE');
2904: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2905: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2906: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2907:
2908: FOR i IN run_actions_tab.FIRST .. run_actions_tab.LAST LOOP
2909: IF run_actions_tab.exists(i) THEN
2910:
2982: IF deduction_elements_tab.COUNT > 0 THEN
2983:
2984: IF master_actions_tab.COUNT>0 THEN
2985:
2986: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2987: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2988: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2989: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2990: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2983:
2984: IF master_actions_tab.COUNT>0 THEN
2985:
2986: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2987: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2988: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2989: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2990: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2991:
2984: IF master_actions_tab.COUNT>0 THEN
2985:
2986: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2987: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2988: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2989: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2990: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2991:
2992: FOR i IN master_actions_tab.FIRST .. master_actions_tab.LAST LOOP
2985:
2986: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2987: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2988: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2989: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2990: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2991:
2992: FOR i IN master_actions_tab.FIRST .. master_actions_tab.LAST LOOP
2993: IF master_actions_tab.exists(i) THEN
2986: pay_us_balance_view_pkg.set_session_var('RUN','FALSE');
2987: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
2988: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
2989: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
2990: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
2991:
2992: FOR i IN master_actions_tab.FIRST .. master_actions_tab.LAST LOOP
2993: IF master_actions_tab.exists(i) THEN
2994: hr_utility.trace('Master Action : ' || master_actions_tab(i).aaid);
3027: ELSE -- SOE for run actions is viewed
3028:
3029: IF p_pre_balance_status = 'Y' and p_aft_balance_status = 'Y' THEN
3030: hr_utility.set_location(l_package||l_procedure,150);
3031: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
3032: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
3033: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
3034: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
3035: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
3028:
3029: IF p_pre_balance_status = 'Y' and p_aft_balance_status = 'Y' THEN
3030: hr_utility.set_location(l_package||l_procedure,150);
3031: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
3032: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
3033: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
3034: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
3035: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
3036: deduction_elements_tab.delete;
3029: IF p_pre_balance_status = 'Y' and p_aft_balance_status = 'Y' THEN
3030: hr_utility.set_location(l_package||l_procedure,150);
3031: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
3032: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
3033: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
3034: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
3035: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
3036: deduction_elements_tab.delete;
3037: p_dedn_tab.delete;
3030: hr_utility.set_location(l_package||l_procedure,150);
3031: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
3032: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
3033: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
3034: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
3035: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
3036: deduction_elements_tab.delete;
3037: p_dedn_tab.delete;
3038: hr_utility.set_location(l_package||l_procedure,160);
3031: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
3032: pay_us_balance_view_pkg.set_session_var('RUN','TRUE');
3033: pay_us_balance_view_pkg.set_session_var('QTD','FALSE');
3034: pay_us_balance_view_pkg.set_session_var('MTD','FALSE');
3035: pay_us_balance_view_pkg.set_session_var('PYDATE','FALSE');
3036: deduction_elements_tab.delete;
3037: p_dedn_tab.delete;
3038: hr_utility.set_location(l_package||l_procedure,160);
3039: OPEN c_get_dedn_elements_rb(p_assignment_action_id);