DBA Data[Home] [Help]

APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_US_SCHOOL_DSTS_TAX_INFO_F

Line 886: from pay_us_school_dsts_tax_info_f pusd

882: ,cp_resident_jurisdiction in varchar2
883: ,cp_effective_date in date
884: ) is
885: select pusd.sch_information1
886: from pay_us_school_dsts_tax_info_f pusd
887: where cp_effective_date between pusd.effective_start_date
888: and pusd.effective_end_date
889: and pusd.state_code = substr(cp_jurisdiction_code, 1, 2)
890: and pusd.school_dsts_code = substr(cp_jurisdiction_code, 4)