[Home] [Help]
View: PAYBV_WC_RATES_V
View Text
SELECT PWCR.WC_CODE
, PWCR.RATE
, PWCR.RATE2
, PWCR.RATE3
, PWCR.RATE_EE
, PWCR.RATE_EE2
, PWCR.PERIOD /* ID COLUMNS */
, PWCR.FUND_ID
, PWCR.BUSINESS_GROUP_ID /* WHO COLUMNS */
, PWCR.LAST_UPDATE_DATE
, PWCR.LAST_UPDATED_BY
, PWCR.CREATED_BY
, PWCR.CREATION_DATE
FROM PAY_WC_RATES PWCR
WHERE PWCR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PWCR.BUSINESS_GROUP_ID) WITH READ ONLY
Columns
Name |
WC_CODE |
RATE |
RATE2 |
RATE3 |
RATE_EE |
RATE_EE2 |
PERIOD |
FUND_ID |
BUSINESS_GROUP_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |