DBA Data[Home] [Help]

APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_US_CITY_TAX_INFO_F

Line 630: from pay_us_city_tax_info_f

626:
627: cursor c_city_tax_exists( cp_jurisdiction_code in varchar2
628: ,cp_effective_date in date) is
629: select city_tax, head_tax, school_tax
630: from pay_us_city_tax_info_f
631: where cp_effective_date between effective_start_date
632: and effective_end_date
633: and jurisdiction_code = cp_jurisdiction_code;
634:

Line 871: from pay_us_city_tax_info_f

867: cursor c_city_agency_code( cp_jurisdiction_code in varchar2
868: ,cp_effective_date in date) is
869: select city_attribute1,
870: nvl(city_attribute2, city_attribute1)
871: from pay_us_city_tax_info_f
872: where cp_effective_date between effective_start_date
873: and effective_end_date
874: and jurisdiction_code = cp_jurisdiction_code
875: and (city_attribute1 is not null or