[Home] [Help]
737: END prc_get_balance;
738:
739: /*************************************************************************
740: routine name: fnc_get_tax_limit_rate
741: purpose: get tax limit rates in table PAY_US_STATE_TAX_INFO_F for
742: specified state and category
743: parameters:
744: return:
745: specs:
759: -- hitting the database for each balance call
760:
761: CURSOR c_sui_sdi_info IS
762: SELECT state_code,sta_information5,sta_information6,sta_information3,sta_information4
763: FROM pay_us_state_tax_info_f pusif
764: WHERE IN_as_of_date <= pusif.effective_end_date
765: AND IN_start_date >= pusif.effective_start_date
766: AND pusif.sta_information_category = 'State tax limit rate info'
767: ORDER BY 1;
1180: END prc_write_data;
1181:
1182: /*************************************************************************
1183: routine name: fnc_sit_exists
1184: purpose: checks table pay_us_state_tax_info_f and return TRUE/FALSE
1185: based on value of column sit_exists.
1186: parameters: IN_state_code -
1187: IN_as_of_date -
1188: return: TRUE/FALSE
1192: IN_as_of_date IN DATE) RETURN BOOLEAN IS
1193:
1194: /********************* 3005756 START ************************************/
1195:
1196: L_sit_exists pay_us_state_tax_info_f.sit_exists%TYPE;
1197:
1198: BEGIN
1199:
1200: IF pay_us_payroll_utils.ltr_state_tax_info.count < 1 THEN