APPS.ARP_RECON_REP dependencies on DUAL

Line 762: from dual;

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

Line 1969: from dual;

1965: ';
1966:
1967: select to_char(sysdate,'YYYY-MM-DD')
1968: into l_report_date
1969: from dual;
1970:
1971: /* Bug 4708930
1972: Get the special characters replaced */
1973: l_reporting_entity_name := format_string(l_reporting_entity_name);

Line 3076: from dual;

3072: ';
3073:
3074: select to_char(sysdate,'YYYY-MM-DD')
3075: into l_report_date
3076: from dual;
3077:
3078: /* Bug 4708930
3079: Get the special characters replaced */
3080: l_reporting_entity_name := format_string(l_reporting_entity_name);

Line 3559: from dual;

3555: ';
3556:
3557: select to_char(sysdate,'YYYY-MM-DD')
3558: into l_report_date
3559: from dual;
3560:
3561: /* Bug 4708930
3562: Get the special characters replaced */
3563: l_reporting_entity_name := format_string(l_reporting_entity_name);

Line 3886: from dual;

3882:
3883: /* Get the format mask for the function currency */
3884: select fnd_currency.get_format_mask(l_functional_currency,40)
3885: into l_format
3886: from dual;
3887: /* Get the period start and end dates */
3888: SELECT p.start_date, p.end_date
3889: INTO l_gl_date_from , l_gl_date_to
3890: FROM gl_periods p, gl_sets_of_books b

Line 4875: from dual;

4871: l_new_line := '
4872: ';
4873: select to_char(sysdate,'YYYY-MM-DD')
4874: into l_report_date
4875: from dual;
4876:
4877: /* Bug 4708930
4878: Get the special characters replaced */
4879: l_reporting_entity_name := format_string(l_reporting_entity_name);