VIEW: APPS.FII_ALL_EFFECTIVE_DATES_V

Source

View Text - Preformatted

SELECT to_char(report_date, 'DD-MON-YYYY') name from fii_time_day WHERE report_date >= bis_common_parameters.get_global_start_date order by report_date

View Text - HTML Formatted

SELECT TO_CHAR(REPORT_DATE
, 'DD-MON-YYYY') NAME
FROM FII_TIME_DAY
WHERE REPORT_DATE >= BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE ORDER BY REPORT_DATE