Skip to content
[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 |