[Home] [Help]
1218: END get_calculated_fed_limit_tax;
1219:
1220: /*************************************************************************
1221: routine name: fnc_get_tax_limit_rate
1222: purpose: get tax limit rates in table PAY_US_STATE_TAX_INFO_F for
1223: specified state and category
1224: parameters:
1225: return:
1226: specs:
1243: -- as against looking for the tax record for the entire period.
1244:
1245: CURSOR c_sui_sdi_info IS
1246: SELECT state_code,sta_information5,sta_information6,sta_information3,sta_information4
1247: FROM pay_us_state_tax_info_f pusif
1248: WHERE IN_as_of_date between pusif.effective_start_date AND pusif.effective_end_date
1249: --IN_as_of_date <= pusif.effective_end_date --Modified for Bug#8665548
1250: --AND IN_start_date >= pusif.effective_start_date --Removed for Bug#8665548
1251: AND pusif.sta_information_category = 'State tax limit rate info'
1665: END prc_write_data;
1666:
1667: /*************************************************************************
1668: routine name: fnc_sit_exists
1669: purpose: checks table pay_us_state_tax_info_f and return TRUE/FALSE
1670: based on value of column sit_exists.
1671: parameters: IN_state_code -
1672: IN_as_of_date -
1673: return: TRUE/FALSE
1677: IN_as_of_date IN DATE) RETURN BOOLEAN IS
1678:
1679: /********************* 3005756 START ************************************/
1680:
1681: L_sit_exists pay_us_state_tax_info_f.sit_exists%TYPE;
1682:
1683: BEGIN
1684:
1685: IF pay_us_payroll_utils.ltr_state_tax_info.count < 1 THEN