Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_US_GARN_EXEMPT_RULES_F_V |
SELECT PGER.EFFECTIVE_START_DATE
, PGER.EFFECTIVE_END_DATE
, PGER.STATE_CODE
, PGER.ADDL_DEP_AMOUNT_VALUE
, PGER.AMOUNT_VALUE
, PGER.CALC_RULE
, PGER.CREATOR_TYPE
, PGER.DEPENDENTS_CALC_RULE
, PGER.DEPENDENT_AMOUNT_VALUE
, PGER.DI_PCT
, PGER.DI_PCT_DEPENDENTS
, PGER.DI_PCT_DEPENDENTS_IN_ARREARS
, PGER.DI_PCT_IN_ARREARS
, PGER.EXEMPTION_BALANCE
, PGER.EXEMPTION_BALANCE_MAX_PCT
, PGER.EXEMPTION_BALANCE_MIN_PCT
, PGER.MARITAL_STATUS
, PGER.MIN_WAGE_FACTOR
, PGER.PRORATION_RULE /* CODES */
, PGER.GARN_CATEGORY
, HR_BIS.BIS_DECODE_LOOKUP('US_INVOLUNTARY_DEDUCTIONS'
, PGER.GARN_CATEGORY) /* ID COLUMNS */
, EXEMPTION_RULE_ID /* WHO COLUMNS */
, PGER.LAST_UPDATE_DATE
, PGER.LAST_UPDATED_BY
, PGER.CREATED_BY
, PGER.CREATION_DATE
FROM PAY_US_GARN_EXEMPTION_RULES_F PGER WITH READ ONLY