Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_US_EMP_CNT_TAX_RULES_F_V |
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