APPS.AP_TURNOVER_RPT_PKG dependencies on DUAL

Line 127: FROM DUAL )

123: - INSTR ( sum_mask, '.', 1, LEVEL)- 1
124: )) AS summary_mask
125: FROM ( SELECT '-' || Acct_num || '-' acc_num
126: , '.' || SUMMARY_MASK_PARAM || '.' sum_mask
127: FROM DUAL )
128: CONNECT BY LEVEL <= LENGTH ( acc_num ) - LENGTH ( REPLACE ( acc_num, '-', '')) - 1;
129: BEGIN
130: IF REPORT_LEVEL_PARAM =4 OR REPORT_LEVEL_PARAM =5 OR REPORT_LEVEL_PARAM =6 THEN
131: IF SUMMARY_MASK_PARAM IS NOT NULL THEN

Line 135: SELECT LENGTH(lcu_Acctnum.account_segments) into ln_length from dual;

131: IF SUMMARY_MASK_PARAM IS NOT NULL THEN
132: FOR lcu_Acctnum IN cu_Acctnum
133: LOOP
134: IF lcu_Acctnum.summary_mask = 'T' THEN
135: SELECT LENGTH(lcu_Acctnum.account_segments) into ln_length from dual;
136: lc_stat := NULL;
137: FOR i IN 1..ln_length LOOP
138: lc_stat := lc_stat||lc_var;
139: END LOOP;