[Home] [Help]
View: PAYBV_WCI_RATES_V
View Text
SELECT PWCIR.CODE
, PWCIR.RATE
, PWCIR.DESCRIPTION
, PWCIR.COMMENTS /* ID COLUMNS */
, PWCIR.RATE_ID
, PWCIR.BUSINESS_GROUP_ID
, PWCIR.ACCOUNT_ID /* WHO COLUMNS */
, PWCIR.LAST_UPDATE_DATE
, PWCIR.LAST_UPDATED_BY
, PWCIR.CREATED_BY
, PWCIR.CREATION_DATE
FROM PAY_WCI_RATES PWCIR
WHERE PWCIR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PWCIR.BUSINESS_GROUP_ID) WITH READ ONLY
Columns
Name |
CODE |
RATE |
DESCRIPTION |
COMMENTS |
RATE_ID |
BUSINESS_GROUP_ID |
ACCOUNT_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |