[Home] [Help]
735: --
736: begin
737: select ''
738: into l_dummy
739: from dual
740: where exists (
741: select ''
742: from pay_payroll_actions ppa,
743: pay_assignment_actions paa,
1893: END IF;
1894: --
1895: SELECT count(0)
1896: INTO l_valid
1897: FROM dual
1898: WHERE p_asg_type in ('ASG','PER','GRE');
1899: --
1900: IF l_valid = 0 THEN
1901: pay_us_balance_view_pkg.debug_err('us_tax_balance: Invalid asg_type: '
1904: END IF;
1905: --
1906: SELECT count(0)
1907: INTO l_valid
1908: FROM dual
1909: WHERE p_time_type in ('RUN','PTD','MONTH','QTD','YTD', 'PAYMENTS', 'PYDATE', 'ASG_PAYMENTS');
1910: --
1911: IF l_valid = 0 THEN
1912: pay_us_balance_view_pkg.debug_err('us_tax_balance: Invalid time_type: '
2239: -- Check if the tax is federal or not.
2240: --
2241: SELECT count(0)
2242: INTO l_test
2243: FROM sys.dual
2244: WHERE l_tax_type in ('FIT','FUTA','MEDICARE','SS','EIC');
2245: --
2246: IF l_test <> 0 THEN -- yes, the tax is federal
2247: --
2858: -- balance retrieval mechanism bypassed as assignment-level route
2859: -- (and latest balances) always used which is not performant for
2860: -- this purpose.
2861: --
2862: -- Maintenance: The cursor should be dual maintained with the row for GRE_YTD in
2863: -- FF_ROUTES.
2864: ---------------------------------------------------------------------------------------
2865: procedure us_gp_multiple_gre_ytd (p_tax_unit_id IN NUMBER,
2866: p_effective_date IN DATE,
3003: -- balance retrieval mechanism bypassed as assignment-level route
3004: -- (and latest balances) always used which is not performant for
3005: -- this purpose.
3006: --
3007: -- Maintenance: The cursor should be dual maintained with the row for GRE_YTD in
3008: -- FF_ROUTES.
3009: ---------------------------------------------------------------------------------------
3010: procedure us_gp_multiple_gre_qtd (p_tax_unit_id IN NUMBER,
3011: p_effective_date IN DATE,
3419: -- from the GRE_JD_YTD route, which is used for State-Level balance
3420: -- reporting. It can return up to 7 balance values. This was coded
3421: -- originally for performance fixing to the GRE Totals Report.
3422: --
3423: -- Maintenance: This should be dual-maintained with the row in FF_ROUTES for
3424: -- GRE_JD_YTD dimension, although note slight changes to main where
3425: -- clause to allow for multiple-decoding.
3426: --
3427: -----------------------------------------------------------------------------------------
3533: -- from the GRE_JD_QTD route, which is used for State-Level balance
3534: -- reporting. It can return up to 7 balance values. This was coded
3535: -- originally for performance fixing to the GRE Totals Report.
3536: --
3537: -- Maintenance: This should be dual-maintained with the row in FF_ROUTES for
3538: -- GRE_JD_QTD dimension, although note slight changes to main where
3539: -- clause to allow for multiple-decoding.
3540: --
3541: -----------------------------------------------------------------------------------------
3659: -- balance retrieval mechanism bypassed as assignment-level route
3660: -- (and latest balances) always used which is not performant for
3661: -- this purpose.
3662: --
3663: -- Maintenance: The cursor should be dual maintained with the row for GRE_MTD in
3664: -- FF_ROUTES.
3665: ---------------------------------------------------------------------------------------
3666: procedure us_gp_multiple_gre_mtd (p_tax_unit_id IN NUMBER,
3667: p_effective_date IN DATE,
3804: -- balance retrieval mechanism bypassed as assignment-level route
3805: -- (and latest balances) always used which is not performant for
3806: -- this purpose.
3807: --
3808: -- Maintenance: The cursor should be dual maintained with the row for GRE_CTD in
3809: -- FF_ROUTES.
3810: ---------------------------------------------------------------------------------------
3811: procedure us_gp_multiple_gre_ctd (p_tax_unit_id IN NUMBER,
3812: p_start_date IN DATE,
4153: -- from the GRE_JD_QTD route, which is used for State-Level balance
4154: -- reporting. It can return up to 7 balance values. This was coded
4155: -- originally for performance fixing to the GRE Totals Report.
4156: --
4157: -- Maintenance: This should be dual-maintained with the row in FF_ROUTES for
4158: -- GRE_JD_MTD dimension, although note slight changes to main where
4159: -- clause to allow for multiple-decoding.
4160: --
4161: -----------------------------------------------------------------------------------------
4268: -- from the GRE_JD_CTD route, which is used for State-Level balance
4269: -- reporting. It can return up to 7 balance values. This was coded
4270: -- originally for performance fixing to the GRE Totals Report.
4271: --
4272: -- Maintenance: This should be dual-maintained with the row in FF_ROUTES for
4273: -- GRE_JD_CTD dimension, although note slight changes to main where
4274: -- clause to allow for multiple-decoding.
4275: --
4276: -----------------------------------------------------------------------------------------