VIEW: APPS.PAYBV_US_EMP_CT_TAX_RULES_F_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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