APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PAY_US_STATE_TAX_INFO_F

Line 6195: l_sui_er_wg_lt_curr_state pay_us_state_tax_info_f.sui_er_wage_limit%type ;

6191: p_state_code in varchar2 default null,
6192: p_session_date in date)
6193: is
6194:
6195: l_sui_er_wg_lt_curr_state pay_us_state_tax_info_f.sui_er_wage_limit%type ;
6196: l_max_asg_eff_st_dt date ;
6197: l_max_pact_dt date ;
6198: l_tax_unit_id number ;
6199: l_defined_balance_id pay_defined_balances.defined_balance_id%type ;

Line 6257: from pay_us_state_tax_info_f

6253: and paf.payroll_id is not null ;
6254:
6255: cursor c_sui_wage_limit(p_state_code in varchar2, p_effective_date in date) is
6256: select sui_er_wage_limit
6257: from pay_us_state_tax_info_f
6258: where p_effective_date between effective_start_date
6259: and effective_end_date
6260: and sta_information_category = 'State tax limit rate info'
6261: and state_code = p_state_code ;