DBA Data[Home] [Help]

APPS.CE_BANK_STATEMENT_LOADER dependencies on DUAL

Line 1839: into G_control_line_count from dual;

1835: G_control_dr_line_count := to_number(l_val3);
1836: select decode(G_control_dr_line_count,null,
1837: G_control_line_count,
1838: nvl(G_control_line_count,0)+G_control_dr_line_count)
1839: into G_control_line_count from dual;
1840: ELSIF l_val1 = '100' THEN
1841: G_control_total_cr := to_number(l_val2)/G_hdr_precision;
1842: /*Bug 3164477 added the following 2 lines for cr line count*/
1843: G_control_cr_line_count := to_number(l_val3);

Line 1847: into G_control_line_count from dual;

1843: G_control_cr_line_count := to_number(l_val3);
1844: select decode(G_control_cr_line_count,null,
1845: G_control_line_count,
1846: nvl(G_control_line_count,0)+G_control_cr_line_count)
1847: into G_control_line_count from dual;
1848: END IF;
1849:
1850:
1851: IF l_val4 = 'S' THEN