DBA Data[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')