eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: HR.PAY_FR_CONTRIBUTION_USAGES#

Source

View Text - Preformatted


select CONTRIBUTION_USAGE_ID CONTRIBUTION_USAGE_ID, DATE_FROM DATE_FROM, DATE_TO DATE_TO, GROUP_CODE GROUP_CODE, PROCESS_TYPE PROCESS_TYPE, ELEMENT_NAME ELEMENT_NAME, RATE_TYPE RATE_TYPE, CONTRIBUTION_CODE CONTRIBUTION_CODE, RETRO_CONTRIBUTION_CODE RETRO_CONTRIBUTION_CODE, CONTRIBUTION_TYPE CONTRIBUTION_TYPE, CONTRIBUTION_USAGE_TYPE CONTRIBUTION_USAGE_TYPE, RATE_CATEGORY RATE_CATEGORY, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CODE_RATE_ID CODE_RATE_ID from "HR"."PAY_FR_CONTRIBUTION_USAGES"

View Text - HTML Formatted

SELECT CONTRIBUTION_USAGE_ID CONTRIBUTION_USAGE_ID
, DATE_FROM DATE_FROM
, DATE_TO DATE_TO
, GROUP_CODE GROUP_CODE
, PROCESS_TYPE PROCESS_TYPE
, ELEMENT_NAME ELEMENT_NAME
, RATE_TYPE RATE_TYPE
, CONTRIBUTION_CODE CONTRIBUTION_CODE
, RETRO_CONTRIBUTION_CODE RETRO_CONTRIBUTION_CODE
, CONTRIBUTION_TYPE CONTRIBUTION_TYPE
, CONTRIBUTION_USAGE_TYPE CONTRIBUTION_USAGE_TYPE
, RATE_CATEGORY RATE_CATEGORY
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CODE_RATE_ID CODE_RATE_ID
FROM "HR"."PAY_FR_CONTRIBUTION_USAGES"