APPS.CE_BANK_STATEMENT_LOADER dependencies on DUAL

Line 2115: into G_control_line_count from dual;

2111: G_control_dr_line_count := to_number(l_val3);
2112: select decode(G_control_dr_line_count,null,
2113: G_control_line_count,
2114: nvl(G_control_line_count,0)+G_control_dr_line_count)
2115: into G_control_line_count from dual;
2116: END IF; -- Bug 9005502 Added if Condition
2117: ELSIF l_val1 = '100' THEN
2118: G_control_total_cr := to_number(l_val2)/G_hdr_precision;
2119: IF(l_val3 IS NOT NULL) THEN -- Bug 9005502 Added if Condition

Line 2125: into G_control_line_count from dual;

2121: G_control_cr_line_count := to_number(l_val3);
2122: select decode(G_control_cr_line_count,null,
2123: G_control_line_count,
2124: nvl(G_control_line_count,0)+G_control_cr_line_count)
2125: into G_control_line_count from dual;
2126: END IF; -- Bug 9005502 Added if Condition
2127: -- Bug 9005502 Start
2128: ELSIF L_VAL1 = '102' THEN
2129: G_control_cr_line_count := to_number(l_val2);