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_RANGE_TEMP#

Source

View Text - Preformatted


select RANGE_ID RANGE_ID, RANGE_TABLE_NUMBER RANGE_TABLE_NUMBER, ROW_VALUE_UOM ROW_VALUE_UOM, PERIOD_FREQUENCY PERIOD_FREQUENCY, EARNINGS_TYPE EARNINGS_TYPE, LOW_BAND LOW_BAND, HIGH_BAND HIGH_BAND, AMOUNT1 AMOUNT1, AMOUNT2 AMOUNT2, AMOUNT3 AMOUNT3, AMOUNT4 AMOUNT4, AMOUNT5 AMOUNT5, AMOUNT6 AMOUNT6, AMOUNT7 AMOUNT7, AMOUNT8 AMOUNT8 from "HR"."PAY_RANGE_TEMP"

View Text - HTML Formatted

SELECT RANGE_ID RANGE_ID
, RANGE_TABLE_NUMBER RANGE_TABLE_NUMBER
, ROW_VALUE_UOM ROW_VALUE_UOM
, PERIOD_FREQUENCY PERIOD_FREQUENCY
, EARNINGS_TYPE EARNINGS_TYPE
, LOW_BAND LOW_BAND
, HIGH_BAND HIGH_BAND
, AMOUNT1 AMOUNT1
, AMOUNT2 AMOUNT2
, AMOUNT3 AMOUNT3
, AMOUNT4 AMOUNT4
, AMOUNT5 AMOUNT5
, AMOUNT6 AMOUNT6
, AMOUNT7 AMOUNT7
, AMOUNT8 AMOUNT8
FROM "HR"."PAY_RANGE_TEMP"