APPS.PA_REPORT_UTIL dependencies on DUAL

Line 498: FROM sys.dual;

494:
495: SELECT
496: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,l_date_format)
497: INTO x_def_period_name
498: FROM sys.dual;
499: /*
500: SELECT
501: TO_CHAR( NEXT_DAY(l_default_date, NVL( TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1, 'DD-MON-YYYY')
502: INTO x_def_period_name

Line 503: FROM sys.dual;

499: /*
500: SELECT
501: TO_CHAR( NEXT_DAY(l_default_date, NVL( TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1, 'DD-MON-YYYY')
502: INTO x_def_period_name
503: FROM sys.dual;
504: */
505: /** Bug 2387429 and 2091182 Code Fix Ends **/
506: x_def_period_name_desc := NULL;
507: ELSIF ( l_period_type = 'YR') THEN

Line 1472: FROM sys.dual;

1468: /*
1469: SELECT
1470: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,'DD-MON-YYYY')
1471: INTO x_def_period_name
1472: FROM sys.dual;
1473: */
1474:
1475: /* NPE Changes -- Shifted this code to the above in this code l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);*/
1476:

Line 1480: FROM sys.dual;

1476:
1477: SELECT
1478: TO_CHAR(NEXT_DAY(l_default_date, NVL(TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')),0)) -1,l_date_format)
1479: INTO x_def_period_name
1480: FROM sys.dual;
1481:
1482: /** Bug 2387429 and 2091182 Code Fix Ends **/
1483:
1484: -- Populating default period year taking from sysdate