FND Design Data [Home] [Help]

View: PAYBV_US_GARN_ARR_RULES_F_V

Product: PAY - Payroll
Description:
Implementation/DBA Data: ViewAPPS.PAYBV_US_GARN_ARR_RULES_F_V
View Text

SELECT PGAR.EFFECTIVE_START_DATE
, PGAR.EFFECTIVE_END_DATE
, PGAR.STATE_CODE
, PGAR.CALC_RULE
, PGAR.CREATOR_TYPE
, PGAR.MAX_PCT_CURRENT
, PGAR.MAX_PCT_DI
, PGAR.MIN_PCT_CURRENT
, PGAR.MIN_PCT_DI /* CODES */
, PGAR.GARN_CATEGORY
, HR_BIS.BIS_DECODE_LOOKUP('US_INVOLUNTARY_DEDUCTIONS'
, PGAR.GARN_CATEGORY) /* ID COLUMNS */
, PGAR.ARREARS_RULE_ID /* WHO COLUMNS */
, PGAR.LAST_UPDATE_DATE
, PGAR.LAST_UPDATED_BY
, PGAR.CREATED_BY
, PGAR.CREATION_DATE
FROM PAY_US_GARN_ARREARS_RULES_F PGAR WITH READ ONLY

Columns

Name
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
STATE_CODE
CALC_RULE
CREATOR_TYPE
MAX_PCT_CURRENT
MAX_PCT_DI
MIN_PCT_CURRENT
MIN_PCT_DI
GARN_CATEGORY_CODE
GARN_CATEGORY
ARREARS_RULE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE