View: PAYBV_US_GARN_LIMIT_RULES_F_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAYBV_US_GARN_LIMIT_RULES_F_V

View Text

SELECT PGLR.EFFECTIVE_START_DATE
, PGLR.EFFECTIVE_END_DATE
, PGLR.STATE_CODE
, PGLR.MAX_WITHHOLDING_AMOUNT
, PGLR.MAX_WITHHOLDING_DURATION_DAYS
, PGLR.MIN_WITHHOLDING_AMOUNT /* CODES */
, PGLR.GARN_CATEGORY
, HR_BIS.BIS_DECODE_LOOKUP('US_INVOLUNTARY_DEDUCTIONS'
, PGLR.GARN_CATEGORY) /* ID COLUMNS */
, PGLR.LIMIT_RULE_ID /* WHO COLUMNS */
, PGLR.LAST_UPDATE_DATE
, PGLR.LAST_UPDATED_BY
, PGLR.CREATED_BY
, PGLR.CREATION_DATE
FROM PAY_US_GARN_LIMIT_RULES_F PGLR WITH READ ONLY

Columns