APPS.PA_REPORT_UTIL dependencies on DUAL

Line 465: FROM sys.dual;

461:
462: SELECT
463: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,l_date_format)
464: INTO x_def_period_name
465: FROM sys.dual;
466: /*
467: SELECT
468: TO_CHAR( NEXT_DAY(l_default_date, NVL( TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1, 'DD-MON-YYYY')
469: INTO x_def_period_name

Line 470: FROM sys.dual;

466: /*
467: SELECT
468: TO_CHAR( NEXT_DAY(l_default_date, NVL( TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1, 'DD-MON-YYYY')
469: INTO x_def_period_name
470: FROM sys.dual;
471: */
472: /** Bug 2387429 and 2091182 Code Fix Ends **/
473: x_def_period_name_desc := NULL;
474: ELSIF ( l_period_type = 'YR') THEN

Line 1424: FROM sys.dual;

1420: /*
1421: SELECT
1422: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,'DD-MON-YYYY')
1423: INTO x_def_period_name
1424: FROM sys.dual;
1425: */
1426:
1427: /* NPE Changes -- Shifted this code to the above in this code l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);*/
1428:

Line 1432: FROM sys.dual;

1428:
1429: SELECT
1430: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,l_date_format)
1431: INTO x_def_period_name
1432: FROM sys.dual;
1433:
1434: /** Bug 2387429 and 2091182 Code Fix Ends **/
1435:
1436: -- Populating default period year taking from sysdate