FND Design Data [Home] [Help]

View: PAYBV_WCI_RATES_V

Product: PAY - Payroll
Description:
Implementation/DBA Data: ViewAPPS.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