DBA Data[Home] [Help]

APPS.HR_AU_TAX_API dependencies on DUAL

Line 312: FROM DUAL

308: 'YP','NP',
309: 'YC','NC',
310: 'N'
311: )
312: FROM DUAL
313: WHERE rownum=1;
314:
315: /* Bug : 2601218 - Cursor to get the tax detail field value from parameters passed */
316: /* Bug : 3318756 - Replaced to_date with fnd_date.chardate_to_date in the select

Line 356: FROM DUAL

352: decode(p_hecs_sfss_flag,'YY','Y','NY','Y','N') ,
353: fnd_date.date_to_canonical(fnd_date.chardate_to_date(p_declaration_signed_date)) ,
354: decode(decode(p_spouse_mls_flag,'Y','Y','N','N','YY','Y','NY','N','N'),'Y','Y',decode(p_savings_rebate_flag,'Y','Y','N')) ,
355: p_tax_file_number
356: FROM DUAL
357: WHERE rownum=1;
358:
359:
360: -- Tax scale temp variable