VIEW: APPS.PAYBV_US_EMP_CNT_TAX_RULES_F_V

Source

View Text - Preformatted

SELECT PUECNTR.EFFECTIVE_START_DATE ,PUECNTR.EFFECTIVE_END_DATE ,PUECNTR.STATE_CODE ,PUECNTR.COUNTY_CODE ,PUECNTR.ADDITIONAL_WA_RATE ,PUECNTR.FILING_STATUS_CODE ,PUECNTR.JURISDICTION_CODE ,PUECNTR.LIT_ADDITIONAL_TAX ,PUECNTR.LIT_OVERRIDE_AMOUNT ,PUECNTR.LIT_OVERRIDE_RATE ,PUECNTR.WITHHOLDING_ALLOWANCES ,PUECNTR.SCHOOL_DISTRICT_CODE /* codes */ ,PUECNTR.LIT_EXEMPT ,HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PUECNTR.LIT_EXEMPT) ,PUECNTR.SD_EXEMPT ,HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PUECNTR.SD_EXEMPT) ,PUECNTR.HT_EXEMPT ,HR_BIS.BIS_DECODE_LOOKUP('YES_NO',PUECNTR.HT_EXEMPT) /* descriptive flexfield */ ,'_DF:PAY:Additional County Tax Info:PUECNTR' ,'_DF:PAY:Further County Tax Info:PUECNTR' /* id columns */ ,PUECNTR.EMP_COUNTY_TAX_RULE_ID ,PUECNTR.BUSINESS_GROUP_ID ,PUECNTR.ASSIGNMENT_ID /* who columns */ ,PUECNTR.LAST_UPDATE_DATE ,PUECNTR.LAST_UPDATED_BY ,PUECNTR.CREATED_BY ,PUECNTR.CREATION_DATE FROM PAY_US_EMP_COUNTY_TAX_RULES_F PUECNTR WHERE PUECNTR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, PUECNTR.BUSINESS_GROUP_ID) WITH READ ONLY

View Text - HTML Formatted

SELECT PUECNTR.EFFECTIVE_START_DATE
, PUECNTR.EFFECTIVE_END_DATE
, PUECNTR.STATE_CODE
, PUECNTR.COUNTY_CODE
, PUECNTR.ADDITIONAL_WA_RATE
, PUECNTR.FILING_STATUS_CODE
, PUECNTR.JURISDICTION_CODE
, PUECNTR.LIT_ADDITIONAL_TAX
, PUECNTR.LIT_OVERRIDE_AMOUNT
, PUECNTR.LIT_OVERRIDE_RATE
, PUECNTR.WITHHOLDING_ALLOWANCES
, PUECNTR.SCHOOL_DISTRICT_CODE /* CODES */
, PUECNTR.LIT_EXEMPT
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUECNTR.LIT_EXEMPT)
, PUECNTR.SD_EXEMPT
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUECNTR.SD_EXEMPT)
, PUECNTR.HT_EXEMPT
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PUECNTR.HT_EXEMPT) /* DESCRIPTIVE FLEXFIELD */
, '_DF:PAY:ADDITIONAL COUNTY TAX INFO:PUECNTR'
, '_DF:PAY:FURTHER COUNTY TAX INFO:PUECNTR' /* ID COLUMNS */
, PUECNTR.EMP_COUNTY_TAX_RULE_ID
, PUECNTR.BUSINESS_GROUP_ID
, PUECNTR.ASSIGNMENT_ID /* WHO COLUMNS */
, PUECNTR.LAST_UPDATE_DATE
, PUECNTR.LAST_UPDATED_BY
, PUECNTR.CREATED_BY
, PUECNTR.CREATION_DATE
FROM PAY_US_EMP_COUNTY_TAX_RULES_F PUECNTR
WHERE PUECNTR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PUECNTR.BUSINESS_GROUP_ID) WITH READ ONLY