APPS.HR_AU_TAX_API dependencies on DUAL

Line 335: FROM DUAL

331: 'YP','NP',
332: 'YC','NC',
333: 'N'
334: )
335: FROM DUAL
336: WHERE rownum=1;
337:
338: /* Bug : 2601218 - Cursor to get the tax detail field value from parameters passed */
339: /* Bug : 3318756 - Replaced to_date with fnd_date.chardate_to_date in the select

Line 382: FROM DUAL

378: fnd_date.date_to_canonical(fnd_date.chardate_to_date(p_declaration_signed_date)) ,
379: decode(decode(p_spouse_mls_flag,'Y','Y','N','N','YY','Y','NY','N','NYA','N','NYB','N','NYC','N','YYA','Y','YYB','Y','YYC','Y','N'),'Y','Y',decode(p_savings_rebate_flag,'Y','Y','N')) ,
380: p_tax_file_number,
381: p_exem_flood_levy_flag
382: FROM DUAL
383: WHERE rownum=1;
384:
385:
386: -- Tax scale temp variable