DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL dependencies on PAY_US_CITY_TAX_INFO_F

Line 239: FROM pay_us_city_tax_info_f puctif

235: /* Code has to join like becuase puctif is not
236: maintained as truely date tracked table
237: */
238: SELECT '1'
239: FROM pay_us_city_tax_info_f puctif
240: WHERE rtrim(ltrim(faic.context)) = puctif.jurisdiction_code
241: AND puctif.effective_start_date < ppa.effective_date
242: AND puctif.effective_end_date >= ppa.effective_date
243: AND puctif.city_information1 like