[Home] [Help]
APPS.PAY_US_MMREF_LOCAL_XML dependencies on PAY_US_CITY_SCHOOL_DSTS
Line 233: from PAY_US_CITY_SCHOOL_DSTS puctif
229: OR
230: ( pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE') <> 'NULL'
231: AND EXISTS
232: ( SELECT '1'
233: from PAY_US_CITY_SCHOOL_DSTS puctif
234: WHERE
235: puctif.state_code = pay_magtape_generic.get_parameter_value('TRANSFER_STATE_CODE')
236: and puctif.state_code ||'-'||
237: puctif.county_code || '-'|| puctif.city_code = pay_magtape_generic.get_parameter_value('TRANSFER_LOCALITY_CODE')