[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 |
APPS.PAYBV_WC_RATES_V