DBA Data[Home] [Help]

VIEW: APPS.HRBV_ANALYSIS_CRITERIA_V

Source

View Text - Preformatted

SELECT ANC.ID_FLEX_NUM, ANC.START_DATE_ACTIVE, ANC.END_DATE_ACTIVE, ANC.SUMMARY_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ANC.SUMMARY_FLAG), ANC.ENABLED_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ANC.ENABLED_FLAG), ANC.SEGMENT2, '_KF:PER:PEA:ANC', ANC.ANALYSIS_CRITERIA_ID, ANC.LAST_UPDATE_DATE, ANC.LAST_UPDATED_BY, ANC.CREATED_BY, ANC.CREATION_DATE FROM PER_ANALYSIS_CRITERIA ANC WITH READ ONLY
View Text - HTML Formatted

SELECT ANC.ID_FLEX_NUM
, ANC.START_DATE_ACTIVE
, ANC.END_DATE_ACTIVE
, ANC.SUMMARY_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ANC.SUMMARY_FLAG)
, ANC.ENABLED_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ANC.ENABLED_FLAG)
, ANC.SEGMENT2
, '_KF:PER:PEA:ANC'
, ANC.ANALYSIS_CRITERIA_ID
, ANC.LAST_UPDATE_DATE
, ANC.LAST_UPDATED_BY
, ANC.CREATED_BY
, ANC.CREATION_DATE
FROM PER_ANALYSIS_CRITERIA ANC WITH READ ONLY