APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PAY_US_STATE_TAX_INFO_F

Line 6119: l_sui_er_wg_lt_curr_state pay_us_state_tax_info_f.sui_er_wage_limit%type ;

6115: p_state_code in varchar2 default null,
6116: p_session_date in date)
6117: is
6118:
6119: l_sui_er_wg_lt_curr_state pay_us_state_tax_info_f.sui_er_wage_limit%type ;
6120: l_max_asg_eff_st_dt date ;
6121: l_max_pact_dt date ;
6122: l_tax_unit_id number ;
6123: l_defined_balance_id pay_defined_balances.defined_balance_id%type ;

Line 6181: from pay_us_state_tax_info_f

6177: and paf.payroll_id is not null ;
6178:
6179: cursor c_sui_wage_limit(p_state_code in varchar2, p_effective_date in date) is
6180: select sui_er_wage_limit
6181: from pay_us_state_tax_info_f
6182: where p_effective_date between effective_start_date
6183: and effective_end_date
6184: and sta_information_category = 'State tax limit rate info'
6185: and state_code = p_state_code ;