DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL dependencies on PAY_US_CITY_TAX_INFO_F

Line 240: FROM pay_us_city_tax_info_f puctif

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