[Home] [Help]
View: PAYBV_CONSOLIDATION_SET
View Text
SELECT PCS.CONSOLIDATION_SET_NAME
, PCS.COMMENTS
, PCS.CONSOLIDATION_SET_ID
, PCS.BUSINESS_GROUP_ID
, PCS.LAST_UPDATE_DATE
, PCS.LAST_UPDATE_LOGIN
, PCS.LAST_UPDATED_BY
, PCS.CREATED_BY
, PCS.CREATION_DATE
, CASE WHEN (PCS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PCS.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_CONSOLIDATION_SETS PCS WITH READ ONLY
Columns
Name |
CONSOLIDATION_SET_NAME |
COMMENTS |
CONSOLIDATION_SET_ID |
BUSINESS_GROUP_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
BG_SECURITY_FLAG_CODE |