DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on PAY_US_STATE_TAX_INFO_F

Line 1111: from pay_us_state_tax_info_f

1107: decode(sui_ee_wage_limit, null, 'N', 'Y'),
1108: decode(sui_er_wage_limit, null, 'N', 'Y'),
1109: decode(sdi_ee_wage_limit, null, 'N', 'Y'),
1110: decode(sdi_er_wage_limit, null, 'N', 'Y')
1111: from pay_us_state_tax_info_f
1112: where cp_effective_date between effective_start_date
1113: and effective_end_date
1114: and sta_information_category = 'State tax limit rate info'
1115: order by 1 ;

Line 6428: from pay_us_state_tax_info_f

6424: date_ear between effective_start_date and effective_end_date;
6425:
6426: cursor state ( st_code varchar2, date_ear date ) IS
6427: select sta_information12,sta_information13
6428: from pay_us_state_tax_info_f
6429: where state_code = st_code and
6430: date_ear between effective_start_date and effective_end_date;
6431:
6432: cursor cnty_name (jur_code varchar2) IS