VIEW: APPS.PAYBV_US_GARN_EXEMPT_RULES_F_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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