DBA Data[Home] [Help]

APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_US_CITY_TAX_INFO_F

Line 651: from pay_us_city_tax_info_f

647:
648: cursor c_city_tax_exists( cp_jurisdiction_code in varchar2
649: ,cp_effective_date in date) is
650: select city_tax, head_tax, school_tax
651: from pay_us_city_tax_info_f
652: where cp_effective_date between effective_start_date
653: and effective_end_date
654: and jurisdiction_code = cp_jurisdiction_code;
655:

Line 915: from pay_us_city_tax_info_f

911: cursor c_city_agency_code( cp_jurisdiction_code in varchar2
912: ,cp_effective_date in date) is
913: select city_attribute1,
914: nvl(city_attribute2, city_attribute1)
915: from pay_us_city_tax_info_f
916: where cp_effective_date between effective_start_date
917: and effective_end_date
918: and jurisdiction_code = cp_jurisdiction_code
919: and (city_attribute1 is not null or