APPS.JA_CN_CFS_CALCULATE_PKG dependencies on DUAL

Line 2070: FROM dual;

2066: SELECT
2067: to_char(nvl(l_amount,0),'FM'||to_char(l_display_format,l_format_mask))
2068: INTO
2069: l_amount_display
2070: FROM dual;
2071: ELSE
2072: SELECT
2073: to_char(nvl(l_amount,0),l_format_mask)
2074: INTO

Line 2076: FROM dual;

2072: SELECT
2073: to_char(nvl(l_amount,0),l_format_mask)
2074: INTO
2075: l_amount_display
2076: FROM dual;
2077: END IF;-- l_display_format IS NOT NULL
2078:
2079:
2080: END IF; --l_display_zero_amount_flag='N' AND NVL(l_amount,0)=0

Line 2101: dual;

2097: )
2098: INTO
2099: l_xml_output_row
2100: FROM
2101: dual;
2102:
2103: --To concatenate xml output
2104: IF l_xml_output IS NULL
2105: THEN

Line 2115: dual;

2111: )
2112: INTO
2113: l_xml_output
2114: FROM
2115: dual;
2116: END IF; --l_xml_output IS NULL
2117:
2118:
2119: --If the type of current row is 'M', then the row is calculated by

Line 2146: FROM dual;

2142: SELECT
2143: decode(l_calculation_lines.operator,'+','-','-','+','+')
2144: INTO
2145: l_operator
2146: FROM dual;
2147: ELSE
2148: l_operator:=l_calculation_lines.operator;
2149: END IF; --_calculation_lines.change_sign_flag='Y'
2150:

Line 2172: dual;

2168: 'FM'||to_char(l_display_format,l_format_mask)
2169: INTO
2170: l_final_display_format
2171: FROM
2172: dual;
2173: ELSE
2174: l_final_display_format:=l_format_mask;
2175: END IF; --l_display_format IS NOT NULL
2176:

Line 2190: dual;

2186: )
2187: INTO
2188: l_xml_output_row
2189: FROM
2190: dual;
2191:
2192: --To concatenate xml output
2193: IF l_xml_output IS NULL
2194: THEN

Line 2204: dual;

2200: )
2201: INTO
2202: l_xml_output
2203: FROM
2204: dual;
2205: END IF; --l_xml_output IS NULL
2206:
2207: --If the type of current row is 'E', then the row is calculated item,but its formual
2208: --is wrong, so amount of current row cannot be calculated, an error message will be

Line 2233: dual;

2229: )
2230: INTO
2231: l_xml_output_row
2232: FROM
2233: dual;
2234:
2235: --To concatenate xml output
2236: IF l_xml_output IS NULL
2237: THEN

Line 2247: dual;

2243: )
2244: INTO
2245: l_xml_output
2246: FROM
2247: dual;
2248: END IF; --l_xml_output IS NULL
2249:
2250: END IF; --l_type='F'
2251: FETCH

Line 2278: FROM dual;

2274: )
2275: ,l_xml_output
2276: )
2277: INTO l_xml_output_root
2278: FROM dual;
2279:
2280: --Replace fsg with fsg; for XML output of fsg segments of main part of
2281: --cash flow statemen, for avoid XML schema analyzing in XML API.
2282: IF l_xml_output_root IS NOT NULL