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.

VIEW: HR.HR_S_US_GARN_EXEMPTION_RULES_#

Source

View Text - Preformatted


select EXEMPTION_RULE_ID EXEMPTION_RULE_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, GARN_CATEGORY GARN_CATEGORY, STATE_CODE STATE_CODE, ADDL_DEP_AMOUNT_VALUE ADDL_DEP_AMOUNT_VALUE, AMOUNT_VALUE AMOUNT_VALUE, CALC_RULE CALC_RULE, CREATOR_TYPE CREATOR_TYPE, DEPENDENTS_CALC_RULE DEPENDENTS_CALC_RULE, DEPENDENT_AMOUNT_VALUE DEPENDENT_AMOUNT_VALUE, DI_PCT DI_PCT, DI_PCT_DEPENDENTS DI_PCT_DEPENDENTS, DI_PCT_DEPENDENTS_IN_ARREARS DI_PCT_DEPENDENTS_IN_ARREARS, DI_PCT_IN_ARREARS DI_PCT_IN_ARREARS, EXEMPTION_BALANCE EXEMPTION_BALANCE, EXEMPTION_BALANCE_MAX_PCT EXEMPTION_BALANCE_MAX_PCT, EXEMPTION_BALANCE_MIN_PCT EXEMPTION_BALANCE_MIN_PCT, MARITAL_STATUS MARITAL_STATUS, MIN_WAGE_FACTOR MIN_WAGE_FACTOR, PRORATION_RULE PRORATION_RULE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE from "HR"."HR_S_US_GARN_EXEMPTION_RULES_F"

View Text - HTML Formatted

SELECT EXEMPTION_RULE_ID EXEMPTION_RULE_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, GARN_CATEGORY GARN_CATEGORY
, STATE_CODE STATE_CODE
, ADDL_DEP_AMOUNT_VALUE ADDL_DEP_AMOUNT_VALUE
, AMOUNT_VALUE AMOUNT_VALUE
, CALC_RULE CALC_RULE
, CREATOR_TYPE CREATOR_TYPE
, DEPENDENTS_CALC_RULE DEPENDENTS_CALC_RULE
, DEPENDENT_AMOUNT_VALUE DEPENDENT_AMOUNT_VALUE
, DI_PCT DI_PCT
, DI_PCT_DEPENDENTS DI_PCT_DEPENDENTS
, DI_PCT_DEPENDENTS_IN_ARREARS DI_PCT_DEPENDENTS_IN_ARREARS
, DI_PCT_IN_ARREARS DI_PCT_IN_ARREARS
, EXEMPTION_BALANCE EXEMPTION_BALANCE
, EXEMPTION_BALANCE_MAX_PCT EXEMPTION_BALANCE_MAX_PCT
, EXEMPTION_BALANCE_MIN_PCT EXEMPTION_BALANCE_MIN_PCT
, MARITAL_STATUS MARITAL_STATUS
, MIN_WAGE_FACTOR MIN_WAGE_FACTOR
, PRORATION_RULE PRORATION_RULE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
FROM "HR"."HR_S_US_GARN_EXEMPTION_RULES_F"