[Home] [Help]
766: --
767: begin
768: select ''
769: into l_dummy
770: from dual
771: where exists (
772: select ''
773: from pay_payroll_actions ppa,
774: pay_assignment_actions paa,
2131: END IF;
2132: --
2133: SELECT count(0)
2134: INTO l_valid
2135: FROM dual
2136: WHERE p_asg_type in ('ASG','PER','GRE');
2137: --
2138: IF l_valid = 0 THEN
2139: pay_us_balance_view_pkg.debug_err('us_tax_balance: Invalid asg_type: '
2142: END IF;
2143: --
2144: SELECT count(0)
2145: INTO l_valid
2146: FROM dual
2147: WHERE p_time_type in ('RUN','PTD','MONTH','QTD','YTD', 'PAYMENTS', 'PYDATE', 'ASG_PAYMENTS');
2148: --
2149: IF l_valid = 0 THEN
2150: pay_us_balance_view_pkg.debug_err('us_tax_balance: Invalid time_type: '
2500: -- Check if the tax is federal or not.
2501: --
2502: SELECT count(0)
2503: INTO l_test
2504: FROM sys.dual
2505: WHERE l_tax_type in ('FIT','FUTA','MEDICARE','SS','EIC');
2506: --
2507: IF l_test <> 0 THEN -- yes, the tax is federal
2508:
3269: -- balance retrieval mechanism bypassed as assignment-level route
3270: -- (and latest balances) always used which is not performant for
3271: -- this purpose.
3272: --
3273: -- Maintenance: The cursor should be dual maintained with the row for GRE_YTD in
3274: -- FF_ROUTES.
3275: ---------------------------------------------------------------------------------------
3276: procedure us_gp_multiple_gre_ytd (p_tax_unit_id IN NUMBER,
3277: p_effective_date IN DATE,
3414: -- balance retrieval mechanism bypassed as assignment-level route
3415: -- (and latest balances) always used which is not performant for
3416: -- this purpose.
3417: --
3418: -- Maintenance: The cursor should be dual maintained with the row for GRE_YTD in
3419: -- FF_ROUTES.
3420: ---------------------------------------------------------------------------------------
3421: procedure us_gp_multiple_gre_qtd (p_tax_unit_id IN NUMBER,
3422: p_effective_date IN DATE,
3889: -- from the GRE_JD_YTD route, which is used for State-Level balance
3890: -- reporting. It can return up to 7 balance values. This was coded
3891: -- originally for performance fixing to the GRE Totals Report.
3892: --
3893: -- Maintenance: This should be dual-maintained with the row in FF_ROUTES for
3894: -- GRE_JD_YTD dimension, although note slight changes to main where
3895: -- clause to allow for multiple-decoding.
3896: --
3897: -----------------------------------------------------------------------------------------
4003: -- from the GRE_JD_QTD route, which is used for State-Level balance
4004: -- reporting. It can return up to 7 balance values. This was coded
4005: -- originally for performance fixing to the GRE Totals Report.
4006: --
4007: -- Maintenance: This should be dual-maintained with the row in FF_ROUTES for
4008: -- GRE_JD_QTD dimension, although note slight changes to main where
4009: -- clause to allow for multiple-decoding.
4010: --
4011: -----------------------------------------------------------------------------------------
4129: -- balance retrieval mechanism bypassed as assignment-level route
4130: -- (and latest balances) always used which is not performant for
4131: -- this purpose.
4132: --
4133: -- Maintenance: The cursor should be dual maintained with the row for GRE_MTD in
4134: -- FF_ROUTES.
4135: ---------------------------------------------------------------------------------------
4136: procedure us_gp_multiple_gre_mtd (p_tax_unit_id IN NUMBER,
4137: p_effective_date IN DATE,
4274: -- balance retrieval mechanism bypassed as assignment-level route
4275: -- (and latest balances) always used which is not performant for
4276: -- this purpose.
4277: --
4278: -- Maintenance: The cursor should be dual maintained with the row for GRE_CTD in
4279: -- FF_ROUTES.
4280: ---------------------------------------------------------------------------------------
4281: procedure us_gp_multiple_gre_ctd (p_tax_unit_id IN NUMBER,
4282: p_start_date IN DATE,
4623: -- from the GRE_JD_QTD route, which is used for State-Level balance
4624: -- reporting. It can return up to 7 balance values. This was coded
4625: -- originally for performance fixing to the GRE Totals Report.
4626: --
4627: -- Maintenance: This should be dual-maintained with the row in FF_ROUTES for
4628: -- GRE_JD_MTD dimension, although note slight changes to main where
4629: -- clause to allow for multiple-decoding.
4630: --
4631: -----------------------------------------------------------------------------------------
4738: -- from the GRE_JD_CTD route, which is used for State-Level balance
4739: -- reporting. It can return up to 7 balance values. This was coded
4740: -- originally for performance fixing to the GRE Totals Report.
4741: --
4742: -- Maintenance: This should be dual-maintained with the row in FF_ROUTES for
4743: -- GRE_JD_CTD dimension, although note slight changes to main where
4744: -- clause to allow for multiple-decoding.
4745: --
4746: -----------------------------------------------------------------------------------------