DBA Data[Home] [Help]

APPS.PAY_US_FLS_REPORTING_PKG dependencies on DUAL

Line 251: from dual

247: *******************************************************************/
248: cursor fls_tax_rec is
249: select 'TRANSFER_PAYMENT_RESPONSIBILITY=P' , 'EE',
250: 'TRANSFER_RESIDENCY=P' , 'R'
251: from dual
252: /* Do not pick EE for FUTA if JD is Federal. Need to
253: check JD and Tax Type as FUTA and SUI have the
254: same Tax Type i.e. UI */
255: where pay_us_fls_reporting_pkg.get_tax_exists(

Line 266: from dual

262: 'EE') = 'Y'
263: UNION ALL
264: select 'TRANSFER_PAYMENT_RESPONSIBILITY=P' , 'ER',
265: 'TRANSFER_RESIDENCY=P' , 'R'
266: from dual
267: /* Return ER for all Jurisdiction where Tax Type is
268: not Income Tax, OPT or EIC */
269: where pay_magtape_generic.get_parameter_value
270: ('TRANSFER_TAX_TYPE_CODE') not in ('IT', 'OPT', 'EIC')

Line 282: from dual

278: 'ER') = 'Y'
279: UNION ALL
280: select 'TRANSFER_PAYMENT_RESPONSIBILITY=P' , 'EE',
281: 'TRANSFER_RESIDENCY=P' , 'NR'
282: from dual
283: /* Check if JD is for local i.e. county_code should not
284: be 000, if <> 000 then return true else check if JD
285: is is school, if yes then retrun false.
286: All other cases return false

Line 304: -- from dual

300: 'EE') = 'Y'
301: -- UNION ALL
302: -- select 'TRANSFER_PAYMENT_RESPONSIBILITY=P' , 'ER',
303: -- 'TRANSFER_RESIDENCY=P' , 'NR'
304: -- from dual
305: -- /* Return ER/NR for all local JD where Tax Type is
306: -- not Income Tax or EIC */
307: -- where pay_magtape_generic.get_parameter_value
308: -- ('TRANSFER_TAX_TYPE_CODE') not in ('IT', 'EIC')