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

Source

View Text - Preformatted


select RANGE_ID RANGE_ID, RANGE_TABLE_ID RANGE_TABLE_ID, LOW_BAND LOW_BAND, HIGH_BAND HIGH_BAND, AMOUNT1 AMOUNT1, AMOUNT2 AMOUNT2, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, AMOUNT3 AMOUNT3, AMOUNT4 AMOUNT4, AMOUNT5 AMOUNT5, AMOUNT6 AMOUNT6, AMOUNT7 AMOUNT7, AMOUNT8 AMOUNT8 from "HR"."PAY_RANGES_F"

View Text - HTML Formatted

SELECT RANGE_ID RANGE_ID
, RANGE_TABLE_ID RANGE_TABLE_ID
, LOW_BAND LOW_BAND
, HIGH_BAND HIGH_BAND
, AMOUNT1 AMOUNT1
, AMOUNT2 AMOUNT2
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AMOUNT3 AMOUNT3
, AMOUNT4 AMOUNT4
, AMOUNT5 AMOUNT5
, AMOUNT6 AMOUNT6
, AMOUNT7 AMOUNT7
, AMOUNT8 AMOUNT8
FROM "HR"."PAY_RANGES_F"