DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL_XML dependencies on PAY_US_CITY_TAX_INFO_F

Line 182: FROM pay_us_city_tax_info_f puctif

178: OR
179: ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') <> 'NULL'
180: AND EXISTS
181: ( SELECT '1'
182: FROM pay_us_city_tax_info_f puctif
183: WHERE substr(rtrim(ltrim(faic.context)),1,2)||'-000-'||substr(rtrim(ltrim(faic.context)),8,4) =
184: substr(puctif.jurisdiction_code,1,2)||'-000-'||substr(puctif.jurisdiction_code,8,4)
185: AND puctif.effective_start_date < PA.effective_date
186: AND puctif.effective_end_date >= PA.effective_date

Line 288: FROM pay_us_city_tax_info_f puctif

284: AND ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') IS NULL
285: OR ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') IS NOT NULL
286: AND EXISTS
287: ( SELECT '1'
288: FROM pay_us_city_tax_info_f puctif
289: WHERE substr(rtrim(ltrim(faic.context)),1,2)||'-000-'||substr(rtrim(ltrim(faic.context)),8,4) =
290: substr(puctif.jurisdiction_code,1,2)||'-000-'||substr(puctif.jurisdiction_code,8,4)
291: AND puctif.effective_start_date < PA.effective_date
292: AND puctif.effective_end_date >= PA.effective_date