APPS.FII_AP_PAID_INV_DETAIL dependencies on DUAL

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

294: FII_ATTRIBUTE6 - Grand Total Discount Taken
295: ***********************************************************************/
296:
297: --Added for Bug 4309974
298: SELECT TO_CHAR(TRUNC(sysdate),'DD/MM/YYYY') INTO l_sysdate FROM dual;
299:
300: /***************Custom drill URLs************************************/
301: l_url_1 := 'AS_OF_DATE='||l_sysdate||'&pFunctionName=FII_AP_INV_ACTIVITY_HISTORY&pParamIds=Y&FII_INVOICE_ID=FII_MEASURE2&FII_INVOICE=FII_MEASURE1'
302: ;