VIEW: APPS.PAYBV_US_GARN_FEE_RULES_F_V

Source

View Text - Preformatted

SELECT PGFR.EFFECTIVE_START_DATE ,PGFR.EFFECTIVE_END_DATE ,PGFR.STATE_CODE ,PGFR.ADDL_GARN_FEE_AMOUNT ,PGFR.CORRESPONDENCE_FEE ,PGFR.CREATOR_TYPE ,PGFR.FEE_AMOUNT ,PGFR.FEE_RULE ,PGFR.MAX_FEE_AMOUNT ,PGFR.PCT_CURRENT ,PGFR.TAKE_FEE_ON_PRORATION /* codes */ ,PGFR.GARN_CATEGORY ,HR_BIS.BIS_DECODE_LOOKUP('US_INVOLUNTARY_DEDUCTIONS',PGFR.GARN_CATEGORY) /* id columns */ ,PGFR.FEE_RULE_ID /* who columns */ ,PGFR.LAST_UPDATE_DATE ,PGFR.LAST_UPDATED_BY ,PGFR.CREATED_BY ,PGFR.CREATION_DATE FROM PAY_US_GARN_FEE_RULES_F PGFR WITH READ ONLY

View Text - HTML Formatted

SELECT PGFR.EFFECTIVE_START_DATE
, PGFR.EFFECTIVE_END_DATE
, PGFR.STATE_CODE
, PGFR.ADDL_GARN_FEE_AMOUNT
, PGFR.CORRESPONDENCE_FEE
, PGFR.CREATOR_TYPE
, PGFR.FEE_AMOUNT
, PGFR.FEE_RULE
, PGFR.MAX_FEE_AMOUNT
, PGFR.PCT_CURRENT
, PGFR.TAKE_FEE_ON_PRORATION /* CODES */
, PGFR.GARN_CATEGORY
, HR_BIS.BIS_DECODE_LOOKUP('US_INVOLUNTARY_DEDUCTIONS'
, PGFR.GARN_CATEGORY) /* ID COLUMNS */
, PGFR.FEE_RULE_ID /* WHO COLUMNS */
, PGFR.LAST_UPDATE_DATE
, PGFR.LAST_UPDATED_BY
, PGFR.CREATED_BY
, PGFR.CREATION_DATE
FROM PAY_US_GARN_FEE_RULES_F PGFR WITH READ ONLY