DBA Data[Home] [Help]

APPS.ARP_RECON_REP dependencies on DUAL

Line 761: from dual;

757: l_new_line := '
758: ';
759: select to_char(sysdate,'YYYY-MM-DD')
760: into l_report_date
761: from dual;
762:
763: /* Bug 4708930
764: Get the special characters replaced */
765: l_reporting_entity_name := format_string(l_reporting_entity_name);

Line 1356: from dual;

1352: ';
1353:
1354: select to_char(sysdate,'YYYY-MM-DD')
1355: into l_report_date
1356: from dual;
1357:
1358: /* Bug 4708930
1359: Get the special characters replaced */
1360: l_reporting_entity_name := format_string(l_reporting_entity_name);

Line 1875: from dual;

1871: ';
1872:
1873: select to_char(sysdate,'YYYY-MM-DD')
1874: into l_report_date
1875: from dual;
1876:
1877: /* Bug 4708930
1878: Get the special characters replaced */
1879: l_reporting_entity_name := format_string(l_reporting_entity_name);

Line 2346: from dual;

2342: ';
2343:
2344: select to_char(sysdate,'YYYY-MM-DD')
2345: into l_report_date
2346: from dual;
2347:
2348: /* Bug 4708930
2349: Get the special characters replaced */
2350: l_reporting_entity_name := format_string(l_reporting_entity_name);

Line 2659: from dual;

2655:
2656: /* Get the format mask for the function currency */
2657: select fnd_currency.get_format_mask(l_functional_currency,40)
2658: into l_format
2659: from dual;
2660: /* Get the period start and end dates */
2661: SELECT p.start_date, p.end_date
2662: INTO l_gl_date_from , l_gl_date_to
2663: FROM gl_periods p, gl_sets_of_books b

Line 3055: from dual;

3051: l_new_line := '
3052: ';
3053: select to_char(sysdate,'YYYY-MM-DD')
3054: into l_report_date
3055: from dual;
3056:
3057: /* Bug 4708930
3058: Get the special characters replaced */
3059: l_reporting_entity_name := format_string(l_reporting_entity_name);