APPS.PAY_US_MMREF_LOCAL dependencies on PAY_US_CITY_TAX_INFO_F

Line 1000: --,pay_us_city_tax_info_f puctif

996: ff_contexts fc1 , --for city context
997: ff_archive_items fai1, -- city
998: ff_archive_item_contexts faic1, -- city_context
999: ff_database_items fdi1 --database_items for City_withheld
1000: --,pay_us_city_tax_info_f puctif
1001: WHERE
1002: ppa1.payroll_action_id = p_pactid
1003: and ppa.business_group_id+0 = ppa1.business_group_id
1004: and ppa1.effective_date = ppa.effective_date

Line 1022: and exists ( select 'x' from pay_us_city_tax_info_f puctif

1018: -- Commented for to generalise locality or ageny code
1019: --and (puctif.city_information1 like 'RITA%'
1020: -- or puctif.city_information1 like 'CCCA%')
1021: --
1022: and exists ( select 'x' from pay_us_city_tax_info_f puctif
1023: where puctif.jurisdiction_code = ltrim(rtrim(faic1.context))
1024: and ltrim(rtrim(faic1.context)) like c_state_code||'%'
1025: and puctif.city_information1 like c_locality_code||'%'
1026: and puctif.effective_start_date < ppa.effective_date