VIEW: APPS.PAYBV_JP_PRE_TAX_V

Source

View Text - Preformatted

SELECT PRE_TAX_ID,ACTION_ID,ASSIGNMENT_ACTION_ID,ACTION_STATUS,SALARY_CATEGORY,TAXABLE_SAL_AMT,TAXABLE_MAT_AMT,PREVIOUS_TAXABLE_AMT,HI_ORGANIZATION_ID,HI_PREM_EE,HI_PREM_ER,WP_ORGANIZATION_ID,WP_PREM_EE,WP_PREM_ER,WPF_ORGANIZATION_ID,WPF_PREM_EE,WPF_PREM_ER,UI_ORGANIZATION_ID,UI_CATEGORY,UI_PREM_EE,UI_SAL_AMT,WAI_ORGANIZATION_ID,WAI_CATEGORY,WAI_SAL_AMT,ITAX_ORGANIZATION_ID,ITAX_CATEGORY,ITAX_YEA_CATEGORY,ITAX,ITAX_ADJUSTMENT,PREVIOUS_ITAX,LTAX_ORGANIZATION_ID,LTAX_DISTRICT_CODE,LTAX_SWOT_NO,LTAX,LTAX_LUMPSUM,SP_LTAX,SP_LTAX_INCOME,SP_LTAX_SHI,SP_LTAX_TO,CI_PREM_EE,CI_PREM_ER,MUTUAL_AID,DISASTER_TAX_REDUCTION,SP_LTAX_DISTRICT_CODE FROM PAY_JP_PRE_TAX

View Text - HTML Formatted

SELECT PRE_TAX_ID
, ACTION_ID
, ASSIGNMENT_ACTION_ID
, ACTION_STATUS
, SALARY_CATEGORY
, TAXABLE_SAL_AMT
, TAXABLE_MAT_AMT
, PREVIOUS_TAXABLE_AMT
, HI_ORGANIZATION_ID
, HI_PREM_EE
, HI_PREM_ER
, WP_ORGANIZATION_ID
, WP_PREM_EE
, WP_PREM_ER
, WPF_ORGANIZATION_ID
, WPF_PREM_EE
, WPF_PREM_ER
, UI_ORGANIZATION_ID
, UI_CATEGORY
, UI_PREM_EE
, UI_SAL_AMT
, WAI_ORGANIZATION_ID
, WAI_CATEGORY
, WAI_SAL_AMT
, ITAX_ORGANIZATION_ID
, ITAX_CATEGORY
, ITAX_YEA_CATEGORY
, ITAX
, ITAX_ADJUSTMENT
, PREVIOUS_ITAX
, LTAX_ORGANIZATION_ID
, LTAX_DISTRICT_CODE
, LTAX_SWOT_NO
, LTAX
, LTAX_LUMPSUM
, SP_LTAX
, SP_LTAX_INCOME
, SP_LTAX_SHI
, SP_LTAX_TO
, CI_PREM_EE
, CI_PREM_ER
, MUTUAL_AID
, DISASTER_TAX_REDUCTION
, SP_LTAX_DISTRICT_CODE
FROM PAY_JP_PRE_TAX