DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL_XML dependencies on PAY_US_CITY_SCHOOL_DSTS

Line 448: AND EXISTS ( SELECT 'x' from PAY_US_CITY_SCHOOL_DSTS puctif

444: AND fai1.archive_item_id = faic1.archive_item_id
445: AND ltrim(rtrim(faic1.context)) like c_state_code||'%'
446: AND (c_locality_code IS NULL OR
447: ( c_locality_code IS NOT NULL
448: AND EXISTS ( SELECT 'x' from PAY_US_CITY_SCHOOL_DSTS puctif
449: WHERE
450: puctif.state_code = c_state_code
451: and puctif.state_code ||'-'||
452: puctif.county_code || '-'|| puctif.city_code = c_locality_code