eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PAYBV_USER_COLUMN

Product:	PAY - Payroll
Description:	Discoverer base view for pay_user_columns.
Implementation/DBA Data:	APPS.PAYBV_USER_COLUMN

View Text

SELECT PUC.USER_COLUMN_NAME
, PUC.LEGISLATION_CODE
, PUC.LEGISLATION_SUBGROUP
, PUC.USER_COLUMN_ID
, PUC.USER_TABLE_ID
, PUC.FORMULA_ID
, PUC.BUSINESS_GROUP_ID
, PUC.LAST_UPDATE_DATE
, PUC.LAST_UPDATED_BY
, PUC.LAST_UPDATE_LOGIN
, PUC.CREATED_BY
, PUC.CREATION_DATE
, PUC.OBJECT_VERSION_NUMBER
, CASE WHEN ((PUC.BUSINESS_GROUP_ID IS NULL
AND PUC.LEGISLATION_CODE IS NULL) OR (PUC.BUSINESS_GROUP_ID IS NULL
AND PUC.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, PUC.LEGISLATION_CODE)) OR (PUC.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PUC.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_USER_COLUMNS PUC WITH READ ONLY

Columns

Name
USER_COLUMN_NAME
LEGISLATION_CODE
LEGISLATION_SUBGROUP
USER_COLUMN_ID
USER_TABLE_ID
FORMULA_ID
BUSINESS_GROUP_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATED_DATE
OBJECT_VERSION_NUMBER
BG_SECURITY_FLAG_CODE