APPS.FII_AR_TRX_ACT_DTL_PKG dependencies on DUAL

Line 144: SELECT TO_CHAR(TRUNC(sysdate),'DD/MM/YYYY') INTO l_sysdate FROM dual;

140: + ag.past_due_bucket_6_amount' || l_col_curr_suffix || '
141: + ag.past_due_bucket_7_amount' || l_col_curr_suffix || '))';
142: END IF;
143:
144: SELECT TO_CHAR(TRUNC(sysdate),'DD/MM/YYYY') INTO l_sysdate FROM dual;
145:
146: l_balance_drill := 'DECODE(outer_inner_query.FII_AR_BALANCE_AMT, NULL, NULL, DECODE(outer_inner_query.FII_AR_TRAN_CLASS,''INV'',
147: ''AS_OF_DATE='||l_sysdate||'&pFunctionName=FII_AR_INV_ACT_HISTORY&FII_AR_CUST_TRX_ID=''||customer_trx_id
148: ||''&FII_AR_TRAN_NUM=FII_AR_TRAN_NUM&FII_AR_TRAN_CLASS=''||outer_inner_query.FII_AR_TRAN_CLASS