DBA Data[Home] [Help]

APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_US_COUNTY_TAX_INFO_F

Line 643: from pay_us_county_tax_info_f puct

639:
640: cursor c_county_tax_exists( cp_jurisdiction_code in varchar2
641: ,cp_effective_date in date) is
642: select puct.county_tax, puct.head_tax, puct.school_tax
643: from pay_us_county_tax_info_f puct
644: where cp_effective_date between puct.effective_start_date
645: and puct.effective_end_date
646: and puct.jurisdiction_code = cp_jurisdiction_code;
647:

Line 901: from pay_us_county_tax_info_f puct

897: cursor c_county_agency_code( cp_jurisdiction_code in varchar2
898: ,cp_effective_date in date) is
899: select puct.cnty_attribute1,
900: nvl(puct.cnty_attribute2, puct.cnty_attribute1)
901: from pay_us_county_tax_info_f puct
902: where cp_effective_date between puct.effective_start_date
903: and puct.effective_end_date
904: and puct.jurisdiction_code = cp_jurisdiction_code
905: and (puct.cnty_attribute1 is not null or