[Home] [Help]
View: PAYBV_WCI_OCCUPATIONS_V
View Text
SELECT PWCO.COMMENTS /* ID COLUMNS */
, PWCO.OCCUPATION_ID
, PWCO.BUSINESS_GROUP_ID
, PWCO.RATE_ID
, PWCO.JOB_ID /* WHO COLUMNS */
, PWCO.LAST_UPDATE_DATE
, PWCO.LAST_UPDATED_BY
, PWCO.CREATED_BY
, PWCO.CREATION_DATE
FROM PAY_WCI_OCCUPATIONS PWCO
WHERE PWCO.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PWCO.BUSINESS_GROUP_ID) WITH READ ONLY
Columns
| Name |
| COMMENTS |
| OCCUPATION_ID |
| BUSINESS_GROUP_ID |
| RATE_ID |
| JOB_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATED_BY |
| CREATION_DATE |
APPS.PAYBV_WCI_OCCUPATIONS_V