View: PAY_PEOPLE_GROUPS_KFV

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_PEOPLE_GROUPS_KFV

View Text

SELECT ROWID
, PEOPLE_GROUP_ID
, ID_FLEX_NUM
, (DECODE(ID_FLEX_NUM
, 101
, SEGMENT13
, NULL))
, (DECODE(ID_FLEX_NUM
, 101
, RPAD(NVL(SEGMENT13
, ' ')
, 60)
, NULL))
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, GROUP_NAME
, SUMMARY_FLAG
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM PAY_PEOPLE_GROUPS

Columns