APPS.PAY_US_MMREF_LOCAL_XML dependencies on PAY_US_CITY_TAX_INFO_F

Line 366: --,pay_us_city_tax_info_f puctif

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

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

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