APPS.PAY_US_W2_GENERIC_EXTRACT dependencies on PAY_US_CITY_SCHOOL_DSTS

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

1634: AND fai1.archive_item_id = faic1.archive_item_id
1635: AND ltrim(rtrim(faic1.context)) like c_state_code||'%'
1636: AND (c_locality_code IS NULL OR
1637: ( c_locality_code IS NOT NULL
1638: AND EXISTS ( SELECT 'x' from PAY_US_CITY_SCHOOL_DSTS puctif
1639: WHERE
1640: puctif.state_code = c_state_code
1641: and puctif.state_code ||'-'||
1642: puctif.county_code || '-'|| puctif.city_code = c_locality_code

Line 1719: from pay_us_city_school_dsts c

1715: IS
1716: SELECT distinct c.school_dst_name,
1717: 'SD' tax_type,
1718: substr(c_jurisdiction_code,4,5) city_code
1719: from pay_us_city_school_dsts c
1720: where c.school_dst_code = substr(c_jurisdiction_code,4,5)
1721: and c.state_code = substr(c_jurisdiction_code,1,2);
1722: -- Bug # 6117216 SD Reporting Changes END
1723: