APPS.PAY_US_MMREF_LOCAL_XML dependencies on PAY_US_CITY_TAX_INFO_F

Line 367: --,pay_us_city_tax_info_f puctif

363: ff_contexts fc1 , --for city context
364: ff_archive_items fai1, -- city
365: ff_archive_item_contexts faic1, -- city_context
366: ff_database_items fdi1 --database_items for City_withheld
367: --,pay_us_city_tax_info_f puctif
368: WHERE ppa1.payroll_action_id = p_pactid
369: AND ppa.business_group_id+0 = ppa1.business_group_id
370: AND ppa1.effective_date = ppa.effective_date
371: AND ppa.report_type = 'YREND'

Line 384: AND EXISTS ( SELECT 'x' from pay_us_city_tax_info_f puctif

380: AND fai1.archive_item_id = faic1.archive_item_id
381: AND ltrim(rtrim(faic1.context)) like c_state_code||'%'
382: AND (c_locality_code IS NULL OR
383: ( c_locality_code IS NOT NULL
384: AND EXISTS ( SELECT 'x' from pay_us_city_tax_info_f puctif
385: WHERE substr(puctif.jurisdiction_code,1,2)||'-000-'||
386: substr(puctif.jurisdiction_code,8,4)
387: = substr(ltrim(rtrim(faic1.context)),1,2)||'-000-'||
388: substr(ltrim(rtrim(faic1.context)),8,4)