APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_US_STATE_TAX_INFO_F

Line 622: from pay_us_state_tax_info_f pust

618: decode(pust.sdi_ee_wage_limit, null, 'N', 'Y'),
619: decode(pust.sdi_er_wage_limit, null, 'N', 'Y'),
620: decode(pust.sui_ee_wage_limit, null, 'N', 'Y'),
621: decode(pust.sui_er_wage_limit, null, 'N', 'Y')
622: from pay_us_state_tax_info_f pust
623: where cp_effective_date between pust.effective_start_date
624: and pust.effective_end_date
625: and pust.state_code = substr(cp_jurisdiction_code, 1,2)
626: and pust.sta_information_category = 'State tax limit rate info';

Line 632: from pay_us_state_tax_info_f pust

628: /* 9164356 start*/
629: cursor c_sdi1_state_tax_exists( cp_jurisdiction_code in varchar2
630: ,cp_effective_date in date) is
631: select 'Y'
632: from pay_us_state_tax_info_f pust
633: where cp_effective_date between pust.effective_start_date
634: and pust.effective_end_date
635: and pust.state_code = substr(cp_jurisdiction_code, 1,2)
636: and pust.sta_information20 IS NOT NULL

Line 887: from pay_us_state_tax_info_f pust

883:
884: cursor c_state_agency_code( cp_jurisdiction_code in varchar2
885: ,cp_effective_date in date) is
886: select pust.sta_information9
887: from pay_us_state_tax_info_f pust
888: where cp_effective_date between pust.effective_start_date
889: and pust.effective_end_date
890: and pust.state_code = substr(cp_jurisdiction_code, 1,2)
891: and pust.sta_information_category = 'State tax limit rate info';