DBA Data[Home] [Help]

APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_US_SCHOOL_DSTS_TAX_INFO_F

Line 930: from pay_us_school_dsts_tax_info_f pusd

926: ,cp_resident_jurisdiction in varchar2
927: ,cp_effective_date in date
928: ) is
929: select pusd.sch_information1
930: from pay_us_school_dsts_tax_info_f pusd
931: where cp_effective_date between pusd.effective_start_date
932: and pusd.effective_end_date
933: and pusd.state_code = substr(cp_jurisdiction_code, 1, 2)
934: and pusd.school_dsts_code = substr(cp_jurisdiction_code, 4)