886: CURSOR csr_get_fed_wage_limits(v_effective_date DATE) IS
887: SELECT ftax.futa_wage_limit,
888: ftax.ss_ee_wage_limit,
889: ftax.ss_er_wage_limit
890: FROM PAY_US_FEDERAL_TAX_INFO_F ftax
891: WHERE v_effective_date BETWEEN ftax.effective_start_date
892: AND ftax.effective_end_date
893: AND ftax.fed_information_category = '401K LIMITS';
894:
1934: /* Get the Medicare EE new limit */
1935: BEGIN
1936: SELECT TO_NUMBER(pft.fed_attribute1) - 0.01 /* Subtract 0.01 from this value as it stores the starting Limit */
1937: INTO l_medi_ee_limit1 /* Bug#15852506 */
1938: FROM pay_us_federal_tax_info_f pft
1939: WHERE pft.fed_information_category = '401K LIMITS'
1940: AND p_adjustment_date BETWEEN pft.effective_start_date AND pft.effective_end_date;
1941: EXCEPTION
1942: WHEN OTHERS THEN