VIEW: APPS.HRI_CL_BACTN_TYP_V

Source

View Text - Preformatted

SELECT distinct type_cd ID, NAME VALUE, TO_DATE ('01/01/1951', 'DD/MM/YYYY') start_date, TO_DATE ('31/12/4712', 'DD/MM/YYYY') end_date, NAME order_by FROM ben_startup_actn_typ_tl where language = userenv('lang') and source_lang = userenv('lang')

View Text - HTML Formatted

SELECT DISTINCT TYPE_CD ID
, NAME VALUE
, TO_DATE ('01/01/1951'
, 'DD/MM/YYYY') START_DATE
, TO_DATE ('31/12/4712'
, 'DD/MM/YYYY') END_DATE
, NAME ORDER_BY
FROM BEN_STARTUP_ACTN_TYP_TL
WHERE LANGUAGE = USERENV('LANG')
AND SOURCE_LANG = USERENV('LANG')