DBA Data[Home] [Help]

APPS.PAY_US_FLS_REPORTING_PKG dependencies on DUAL

Line 260: from dual

256: *******************************************************************/
257: cursor fls_tax_rec is
258: select 'TRANSFER_PAYMENT_RESPONSIBILITY=P' , 'EE',
259: 'TRANSFER_RESIDENCY=P' , 'R'
260: from dual
261: /* Do not pick EE for FUTA if JD is Federal. Need to
262: check JD and Tax Type as FUTA and SUI have the
263: same Tax Type i.e. UI */
264: where pay_us_fls_reporting_pkg.get_tax_exists(

Line 275: from dual

271: 'EE') = 'Y'
272: UNION ALL
273: select 'TRANSFER_PAYMENT_RESPONSIBILITY=P' , 'ER',
274: 'TRANSFER_RESIDENCY=P' , 'R'
275: from dual
276: /* Return ER for all Jurisdiction where Tax Type is
277: not Income Tax, OPT or EIC */
278: where pay_magtape_generic.get_parameter_value
279: ('TRANSFER_TAX_TYPE_CODE') not in ('IT', 'OPT', 'EIC')

Line 291: from dual

287: 'ER') = 'Y'
288: UNION ALL
289: select 'TRANSFER_PAYMENT_RESPONSIBILITY=P' , 'EE',
290: 'TRANSFER_RESIDENCY=P' , 'NR'
291: from dual
292: /* Check if JD is for local i.e. county_code should not
293: be 000, if <> 000 then return true else check if JD
294: is is school, if yes then retrun false.
295: All other cases return false

Line 313: -- from dual

309: 'EE') = 'Y'
310: -- UNION ALL
311: -- select 'TRANSFER_PAYMENT_RESPONSIBILITY=P' , 'ER',
312: -- 'TRANSFER_RESIDENCY=P' , 'NR'
313: -- from dual
314: -- /* Return ER/NR for all local JD where Tax Type is
315: -- not Income Tax or EIC */
316: -- where pay_magtape_generic.get_parameter_value
317: -- ('TRANSFER_TAX_TYPE_CODE') not in ('IT', 'EIC')