DBA Data[Home] [Help]

APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_US_COUNTY_TAX_INFO_F

Line 622: from pay_us_county_tax_info_f puct

618:
619: cursor c_county_tax_exists( cp_jurisdiction_code in varchar2
620: ,cp_effective_date in date) is
621: select puct.county_tax, puct.head_tax, puct.school_tax
622: from pay_us_county_tax_info_f puct
623: where cp_effective_date between puct.effective_start_date
624: and puct.effective_end_date
625: and puct.jurisdiction_code = cp_jurisdiction_code;
626:

Line 857: from pay_us_county_tax_info_f puct

853: cursor c_county_agency_code( cp_jurisdiction_code in varchar2
854: ,cp_effective_date in date) is
855: select puct.cnty_attribute1,
856: nvl(puct.cnty_attribute2, puct.cnty_attribute1)
857: from pay_us_county_tax_info_f puct
858: where cp_effective_date between puct.effective_start_date
859: and puct.effective_end_date
860: and puct.jurisdiction_code = cp_jurisdiction_code
861: and (puct.cnty_attribute1 is not null or