View: HR_ADP_WORK_STATE_TAX_V

Product:	PER - Human Resources
Description:	ADP payroll interface view
Implementation/DBA Data:	APPS.HR_ADP_WORK_STATE_TAX_V

View Text

SELECT /*+ ORDERED PUSH_SUBQ */ REF.COMPANY_CODE_EQUIVALENT COMPANY_CODE_EQUIVALENT
, HOU.NAME GRE_NAME
, HS.SEGMENT1 GRE_ID
, PASG.ORGANIZATION_ID ORGANIZATION_ID
, PP.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PP.PERSON_ID PERSON_ID
, DECODE(PTP.NUMBER_PER_FISCAL_YEAR
, 52
, 'W'
, 24
, 'S'
, 26
, 'B'
, 12
, 'M'
, PTP.NUMBER_PER_FISCAL_YEAR) PAY_FREQUENCY
, PASG.ASSIGNMENT_ID ASSIGNMENT_ID
, PASG.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, DECODE(PASG.PRIMARY_FLAG
, 'Y'
, 0
, PASG.ASSIGNMENT_SEQUENCE) ASSIGNMENT_SEQUENCE
, PASG.PRIMARY_FLAG PRIMARY_FLAG
, PFT.EFFECTIVE_START_DATE FIT_EFFECTIVE_START_DATE
, PFT.EFFECTIVE_END_DATE FIT_EFFECTIVE_END_DATE
, PFT.FILING_STATUS_CODE FIT_FILING_STATUS
, DECODE (PFT.FILING_STATUS_CODE
, '01'
, 'S'
, '02'
, 'M'
, '03'
, 'H'
, '04'
, 'F'
, PFT.FILING_STATUS_CODE) FIT_FILING_STATUS_CODE
, TO_NUMBER(PFT.WITHHOLDING_ALLOWANCES) FIT_EXEMPTIONS
, TO_NUMBER(PFT.FIT_OVERRIDE_AMOUNT) FIT_OVERRIDE_AMOUNT
, TO_NUMBER(PFT.FIT_OVERRIDE_RATE) FIT_OVERRIDE_RATE
, PFT.STATUTORY_EMPLOYEE STATUTORY_EMPLOYEE_FLAG
, TO_NUMBER(PFT.FIT_ADDITIONAL_TAX) FIT_ADDITIONAL_TAX
, PFT.EIC_FILING_STATUS_CODE EIC_FILING_STATUS
, PFT.FIT_EXEMPT FIT_EXEMPT_FLAG
, DECODE(PFT.MEDICARE_TAX_EXEMPT
, 'Y'
, 'Y'
, 'N') MEDICARE_EXEMPT_FLAG
, DECODE(PFT.FUTA_TAX_EXEMPT
, 'Y'
, 'Y'
, 'N') FUTA_EXEMPT_FLAG
, DECODE(PFT.SS_TAX_EXEMPT
, 'Y'
, 'Y'
, 'N') SS_EXEMPT_FLAG
, DECODE(PFT.CUMULATIVE_TAXATION
, 'Y'
, 'Y'
, 'N') CUMULATIVE_TAXATION_FLAG
, PSR2.STATE_CODE SUI_STATE_NAME
, PSR2.STATE_CODE SUI_STATE_CODE
, SIT.EFFECTIVE_START_DATE SIT_EFFECTIVE_START_DATE
, SIT.EFFECTIVE_END_DATE SIT_EFFECTIVE_END_DATE
, TO_NUMBER(SIT.WITHHOLDING_ALLOWANCES) SIT_EXEMPTIONS
, TO_NUMBER(SIT.SIT_OVERRIDE_AMOUNT) SIT_OVERRIDE_AMOUNT
, TO_NUMBER(SIT.SIT_OVERRIDE_RATE) SIT_OVERRIDE_RATE
, HRL.MEANING SIT_FILING_STATUS
, SIT.FILING_STATUS_CODE SIT_FILING_STATUS_CODE
, SIT.SIT_ADDITIONAL_TAX SIT_ADDITIONAL_TAX
, SIT.SIT_EXEMPT SIT_EXEMPT_FLAG
, SIT.ADDITIONAL_WA_AMOUNT SIT_EXEMPTION_AMOUNT
, SIT.SIT_OPTIONAL_CALC_IND SIT_OPTIONAL_CALC
, SIT.SECONDARY_WA SIT_SECONDARY_ALLOWANCES
, SIT.SUI_WAGE_BASE_OVERRIDE_AMOUNT SUI_WAGE_BASE_OVERRIDE_AMOUNT
, TO_NUMBER(PFT.SUPP_TAX_OVERRIDE_RATE) FIT_SUPP_OVERRIDE_RATE
, HRL2.MEANING LIT_FILING_STATUS
, LIT.FILING_STATUS_CODE LIT_FILING_STATUS_CODE
, LIT.EFFECTIVE_START_DATE LIT_EFFECTIVE_START_DATE
, LIT.EFFECTIVE_END_DATE LIT_EFFECTIVE_END_DATE
, LIT.LIT_OVERRIDE_AMOUNT LIT_OVERRIDE_AMOUNT
, LIT.SCHOOL_DISTRICT_CODE SCHOOL_DISTRICT_CODE
, NVL(HL.LOC_INFORMATION17
, HL.REGION_2) WORK_STATE_CODE
, NVL(HL.LOC_INFORMATION17
, HL.REGION_2) WORK_STATE_NAME
, TO_NUMBER(LIT.LIT_ADDITIONAL_TAX) LIT_ADDITIONAL_TAX
, TO_NUMBER(LIT.LIT_OVERRIDE_RATE) LIT_OVERRIDE_RATE
, TO_NUMBER(LIT.WITHHOLDING_ALLOWANCES) LIT_EXEMPTIONS
, NVL(LIT.SD_EXEMPT
, 'N') SCHOOL_DISTRICT_TAX_FLAG
, LIT.JURISDICTION_CODE LOCAL_TAX_CODE
, CN.CITY_NAME LOCAL_JURISDICTION
, NVL(HL.LOC_INFORMATION19
, HL.REGION_1) COUNTY_NAME
, LIT.LIT_EXEMPT LIT_EXEMPT_FLAG
, DECODE(SIT.SUI_EXEMPT
, 'Y'
, 'Y'
, 'N') SUI_EXEMPT_FLAG
, DECODE(SIT.SDI_EXEMPT
, 'Y'
, 'Y'
, 'N') SDI_EXEMPT_FLAG
, DECODE(SIT.WC_EXEMPT
, 'Y'
, 'Y'
, 'N') WC_EXEMPT_FLAG
, DECODE(SIT.STATE_NON_RESIDENT_CERT
, 'Y'
, 'Y'
, 'N') STATE_NON_RESIDENT_CERT
, DECODE(LIT.HT_EXEMPT
, 'Y'
, 'Y'
, 'N') OCC_PRIV_TAX_EXEMPT
, SIT.SUPP_TAX_OVERRIDE_RATE SIT_SUPP_OVERRIDE_RATE
, LIT.ADDITIONAL_WA_RATE LIT_ADDITIONAL_ALLOWANCE_RATE
, NVL(PSTX.SIT_EXISTS
, 'N') SIT_EXISTS
, NVL(PCTX.CITY_TAX
, 'N') LIT_EXISTS
, GREATEST ( DECODE( GREATEST( TRUNC(HR_ADP.GET_ADP_EXTRACT_DATE)
, NVL(REF.FINAL_PROCESS_DATE
, TO_DATE ('1900/01/01'
, 'YYYY/MM/DD')))
, TRUNC(HR_ADP.GET_ADP_EXTRACT_DATE)
, GREATEST(NVL((DECODE(PASG2.EFFECTIVE_END_DATE
, TO_DATE('31-12-4712'
, 'DD-MM-YYYY')
, TO_DATE('31-12-1899'
, 'DD-MM-YYYY')
, PPS.FINAL_PROCESS_DATE
, PPS.FINAL_PROCESS_DATE - 1
, PASG2.EFFECTIVE_END_DATE) + 1)
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, NVL(PP.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PP.EFFECTIVE_START_DATE
, NVL(PASG.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PASG.EFFECTIVE_START_DATE
, NVL(REF.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, NVL(REF.FINAL_PROCESS_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, NVL(PFT.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, NVL(PFT3.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, NVL(PA.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, NVL(PA.DATE_FROM
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PFT.EFFECTIVE_START_DATE
, PFT3.EFFECTIVE_START_DATE
, NVL(SIT.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, SIT.EFFECTIVE_START_DATE
, NVL(SIT3.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, SIT3.EFFECTIVE_START_DATE
, NVL(LIT.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, LIT.EFFECTIVE_START_DATE
, NVL(LIT3.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, LIT3.EFFECTIVE_START_DATE
, NVL(HL.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD')))
, GREATEST(NVL(REF.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, NVL(PP.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PP.EFFECTIVE_START_DATE
, NVL(PASG.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PASG.EFFECTIVE_START_DATE
, NVL(PFT.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, NVL(PFT3.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, NVL(PA.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, NVL(PA.DATE_FROM
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PFT.EFFECTIVE_START_DATE
, PFT3.EFFECTIVE_START_DATE
, NVL(SIT.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, SIT.EFFECTIVE_START_DATE
, NVL(SIT3.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, SIT3.EFFECTIVE_START_DATE
, NVL(LIT.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, LIT.EFFECTIVE_START_DATE
, NVL(LIT3.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, LIT3.EFFECTIVE_START_DATE
, NVL(HL.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))))
, REF.DATE_START) GREATEST_LAST_UPDATE_DATE
FROM /* PLEASE DO NOT CHANGE THE TABLE ORDER */ /* NOTE: THE CBO FOR 8.1.6 SEEMS TO BE CHOOSING THE WRONG TABLE ORDER
, HENCE THE FORCED ORDERED HINT. THIS IS A CULMINATION OF A KNOWN CBO BUG WHICH IS FIXED IN 9I
AND THE SECURE VIEW PAY_PAYROLLS_F. BECAUSE OF THE NATURE OF THE VIEW
,
AND THE WAY IT IS USED
, THIS SHOULD NOT CAUSE PROBLEMS
, HOWEVER
, FOR 9I SHOULD RE-EVALUATE THE HINTS. THE USE OF THE PUSH_SUBQ HINT HELPS THE VIEW TO FILTER OUT ROWS EARLIER
,
AND AGAIN SHOULD BE RE-EVALUATED. */ PAY_US_EMP_FED_TAX_RULES_F PFT
, HR_ADP_EMP_REF_V REF
, PAY_US_EMP_STATE_TAX_RULES_F SIT
, PAY_US_EMP_CITY_TAX_RULES_F LIT
, PER_ALL_ASSIGNMENTS_F PASG
, PER_PERIODS_OF_SERVICE PPS
, HR_SOFT_CODING_KEYFLEX HS
, PER_ADDRESSES PA
, HR_LOCATIONS_ALL HL
, PAY_US_CITY_NAMES CN
, PAY_US_STATES PUST
, PAY_US_STATES PUST2
, PAY_STATE_RULES PSR
, PER_TIME_PERIOD_TYPES PTP
, PER_ALL_PEOPLE_F PP
, HR_LOOKUPS HRL
, HR_LOOKUPS HRL2
, PAY_US_COUNTIES C
, HR_ALL_ORGANIZATION_UNITS HOU
, PAY_US_EMP_FED_TAX_RULES_F PFT3
, PAY_US_EMP_STATE_TAX_RULES_F SIT3
, PAY_US_EMP_CITY_TAX_RULES_F LIT3
, PER_ALL_ASSIGNMENTS_F PASG2
, PAY_US_CITY_NAMES CN4
, PAY_US_CITY_NAMES CN3
, PAY_US_STATES PUST3
, PAY_STATE_RULES PSR3
, HR_LOOKUPS HRL3
, HR_LOOKUPS HRL4
, PAY_US_COUNTIES C2
, PAY_US_CITY_NAMES CN2
, PAY_US_STATE_TAX_INFO_F PSTX
, PAY_US_CITY_TAX_INFO_F PCTX
, PAY_STATE_RULES PSR2
, PAY_STATE_RULES PSR4
WHERE REF.PERIOD_TYPE = PTP.PERIOD_TYPE
AND HL.STYLE = 'US'
AND PPS.PERIOD_OF_SERVICE_ID = PASG.PERIOD_OF_SERVICE_ID
AND HS.SOFT_CODING_KEYFLEX_ID = PASG.SOFT_CODING_KEYFLEX_ID
AND HS.SEGMENT1 = HOU.ORGANIZATION_ID
AND PASG.ROWID = REF.ASG_ROWID
AND PP.ROWID = REF.PER_ROWID
AND HL.LOCATION_ID = NVL(HS.SEGMENT18
, PASG.LOCATION_ID)
AND PA.PERSON_ID = REF.PERSON_ID
AND PA.PRIMARY_FLAG = 'Y'
AND PA.STYLE = 'US'
AND (PA.DATE_FROM <= TRUNC(HR_ADP.GET_ADP_EXTRACT_DATE)
AND (PA.DATE_TO IS NULL OR PA.DATE_TO >= TRUNC(HR_ADP.GET_ADP_EXTRACT_DATE)))
AND PFT.ASSIGNMENT_ID = REF.ASSIGNMENT_ID
AND SIT.ASSIGNMENT_ID = REF.ASSIGNMENT_ID
AND LIT.ASSIGNMENT_ID = SIT.ASSIGNMENT_ID
AND PASG2.ASSIGNMENT_ID = PASG.ASSIGNMENT_ID
AND PASG2.ASSIGNMENT_TYPE = 'E'
AND PASG2.EFFECTIVE_START_DATE = (SELECT MAX(PASG3.EFFECTIVE_START_DATE)
FROM PER_ALL_ASSIGNMENTS_F PASG3
WHERE PASG3.ASSIGNMENT_ID = PASG.ASSIGNMENT_ID
AND PASG3.EFFECTIVE_START_DATE <= PASG.EFFECTIVE_START_DATE
AND ((PASG3.LOCATION_ID <> PASG.LOCATION_ID) OR (PASG3.LOCATION_ID = PASG.LOCATION_ID
AND PASG3.EFFECTIVE_START_DATE = (SELECT MIN(PASG4.EFFECTIVE_START_DATE)
FROM PER_ALL_ASSIGNMENTS_F PASG4
WHERE PASG4.ASSIGNMENT_ID = PASG.ASSIGNMENT_ID
AND PASG4.ASSIGNMENT_TYPE = 'E'))))
AND PFT.EFFECTIVE_START_DATE = (SELECT MAX(PFT2.EFFECTIVE_START_DATE)
FROM PAY_US_EMP_FED_TAX_RULES_F PFT2
WHERE PFT2.EFFECTIVE_START_DATE <= TRUNC(HR_ADP.GET_ADP_EXTRACT_DATE)
AND PFT2.EMP_FED_TAX_RULE_ID = PFT.EMP_FED_TAX_RULE_ID)
AND SIT.EFFECTIVE_START_DATE = (SELECT MAX(SIT2.EFFECTIVE_START_DATE)
FROM PAY_US_EMP_STATE_TAX_RULES_F SIT2
WHERE SIT2.EFFECTIVE_START_DATE <= TRUNC(HR_ADP.GET_ADP_EXTRACT_DATE)
AND SIT2.EMP_STATE_TAX_RULE_ID = SIT.EMP_STATE_TAX_RULE_ID)
AND LIT.EFFECTIVE_START_DATE = (SELECT MAX(LIT2.EFFECTIVE_START_DATE)
FROM PAY_US_EMP_CITY_TAX_RULES_F LIT2
WHERE LIT2.EFFECTIVE_START_DATE <= TRUNC(HR_ADP.GET_ADP_EXTRACT_DATE)
AND LIT2.EMP_CITY_TAX_RULE_ID = LIT.EMP_CITY_TAX_RULE_ID)
AND SIT.STATE_CODE = PUST.STATE_CODE
AND PUST.STATE_ABBREV = NVL(HL.LOC_INFORMATION17
, HL.REGION_2)
AND HRL.LOOKUP_CODE = TO_CHAR(TO_NUMBER(SIT.FILING_STATUS_CODE))
AND HRL.LOOKUP_TYPE = PSR.FS_LOOKUP_TYPE
AND HRL2.LOOKUP_CODE = LIT.FILING_STATUS_CODE
AND HRL2.LOOKUP_TYPE = 'US_LIT_FILING_STATUS'
AND SIT.STATE_CODE = PUST2.STATE_CODE
AND PUST2.STATE_ABBREV = PSR.STATE_CODE /* FTS HERE - PAYROLL ADVISED THAT THEY SHOULD INDEX PAY_STATE_RULES.JURISDICTION_CODE */
AND PSR2.JURISDICTION_CODE = PFT.SUI_JURISDICTION_CODE
AND C.COUNTY_NAME = NVL(HL.LOC_INFORMATION19
, HL.REGION_1)
AND C.COUNTY_CODE = SUBSTR(LIT.JURISDICTION_CODE
, 4
, 3)
AND C.STATE_CODE = SUBSTR(LIT.JURISDICTION_CODE
, 1
, 2)
AND SUBSTR(LIT.JURISDICTION_CODE
, 8
, 4) <> '0000'
AND CN2.CITY_NAME = NVL(HL.LOC_INFORMATION18
, HL.TOWN_OR_CITY)
AND CN2.CITY_CODE = LIT.CITY_CODE
AND CN2.COUNTY_CODE = LIT.COUNTY_CODE
AND CN2.STATE_CODE = LIT.STATE_CODE
AND CN.STATE_CODE = LIT.STATE_CODE
AND CN.COUNTY_CODE = LIT.COUNTY_CODE
AND CN.CITY_CODE = LIT.CITY_CODE
AND ((CN.PRIMARY_FLAG = 'Y') OR (CN.PRIMARY_FLAG = 'N'
AND CN.CITY_CODE LIKE 'U%'))
AND LIT.JURISDICTION_CODE = PCTX.JURISDICTION_CODE (+)
AND HR_ADP.GET_ADP_EXTRACT_DATE BETWEEN PCTX.EFFECTIVE_START_DATE (+)
AND PCTX.EFFECTIVE_END_DATE (+)
AND SIT.STATE_CODE = PSTX.STATE_CODE (+)
AND HR_ADP.GET_ADP_EXTRACT_DATE BETWEEN PSTX.EFFECTIVE_START_DATE (+)
AND PSTX.EFFECTIVE_END_DATE (+)
AND PFT3.ASSIGNMENT_ID = REF.ASSIGNMENT_ID
AND PFT3.EFFECTIVE_START_DATE = (SELECT MAX(PFT4.EFFECTIVE_START_DATE)
FROM PAY_US_EMP_FED_TAX_RULES_F PFT4
WHERE PFT4.EFFECTIVE_START_DATE <= TRUNC(HR_ADP.GET_ADP_EXTRACT_DATE)
AND PFT4.EMP_FED_TAX_RULE_ID = PFT.EMP_FED_TAX_RULE_ID)
AND /* FTS HERE - PAYROLL ADVISED THAT THEY SHOULD INDEX PAY_STATE_RULES.JURISDICTION_CODE */ PSR4.JURISDICTION_CODE = PFT3.SUI_JURISDICTION_CODE
AND SIT3.ASSIGNMENT_ID = PFT3.ASSIGNMENT_ID
AND SIT3.EFFECTIVE_START_DATE = (SELECT MAX(SIT4.EFFECTIVE_START_DATE)
FROM PAY_US_EMP_STATE_TAX_RULES_F SIT4
WHERE SIT4.EFFECTIVE_START_DATE <= TRUNC(HR_ADP.GET_ADP_EXTRACT_DATE)
AND SIT4.EMP_STATE_TAX_RULE_ID = SIT3.EMP_STATE_TAX_RULE_ID)
AND PUST3.STATE_CODE = SIT3.STATE_CODE
AND PUST3.STATE_ABBREV = NVL(PA.ADD_INFORMATION17
, PA.REGION_2)
AND C2.COUNTY_NAME = NVL(PA.ADD_INFORMATION19
, PA.REGION_1)
AND C2.COUNTY_CODE = SUBSTR(LIT3.JURISDICTION_CODE
, 4
, 3)
AND C2.STATE_CODE = SUBSTR(LIT3.JURISDICTION_CODE
, 1
, 2)
AND SUBSTR(LIT3.JURISDICTION_CODE
, 8
, 4) <> '0000'
AND LIT3.ASSIGNMENT_ID = SIT3.ASSIGNMENT_ID
AND LIT3.EFFECTIVE_START_DATE = (SELECT MAX(LIT4.EFFECTIVE_START_DATE)
FROM PAY_US_EMP_CITY_TAX_RULES_F LIT4
WHERE LIT4.EFFECTIVE_START_DATE <= TRUNC(HR_ADP.GET_ADP_EXTRACT_DATE)
AND LIT4.EMP_CITY_TAX_RULE_ID = LIT3.EMP_CITY_TAX_RULE_ID)
AND CN4.CITY_NAME = NVL(PA.ADD_INFORMATION18
, PA.TOWN_OR_CITY)
AND CN4.CITY_CODE = LIT3.CITY_CODE
AND CN4.COUNTY_CODE = LIT3.COUNTY_CODE
AND CN4.STATE_CODE = LIT3.STATE_CODE
AND CN3.STATE_CODE = LIT3.STATE_CODE
AND CN3.COUNTY_CODE = LIT3.COUNTY_CODE
AND CN3.CITY_CODE = LIT3.CITY_CODE
AND ((CN3.PRIMARY_FLAG = 'Y') OR (CN3.PRIMARY_FLAG = 'N'
AND CN3.CITY_CODE LIKE 'U%'))
AND PSR3.STATE_CODE = PUST3.STATE_ABBREV
AND HRL3.LOOKUP_TYPE = PSR3.FS_LOOKUP_TYPE
AND HRL3.LOOKUP_CODE = TO_CHAR(TO_NUMBER(SIT3.FILING_STATUS_CODE))
AND HRL4.LOOKUP_TYPE = 'US_LIT_FILING_STATUS'
AND HRL4.LOOKUP_CODE = LIT3.FILING_STATUS_CODE

Columns