View: PAY_US_LOCAL_ACTION_INFO_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_US_LOCAL_ACTION_INFO_V

View Text

SELECT PER.FULL_NAME EMPLOYEE_NAME
, PPL.EFFECTIVE_DATE PAYROLL_DATE
, ASG.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, CITY.ACTION_CONTEXT_ID ASSIGNMENT_ACTION_ID
, CITY.JURISDICTION_CODE JURISDICTION_CODE
, CITY.TAX_UNIT_ID TAX_UNIT_ID
, TAX.NAME GRE
, TO_NUMBER(COUNTY.ACTION_INFORMATION1 ) COUNTY_WITHHELD
, TO_NUMBER(COUNTY.ACTION_INFORMATION2 ) COUNTY_SUBJ_WHABLE
, TO_NUMBER(COUNTY.ACTION_INFORMATION3 ) COUNTY_SUBJ_NWABLE
, TO_NUMBER(COUNTY.ACTION_INFORMATION4 ) COUNTY_PRE_TAX_REDNS
, TO_NUMBER(COUNTY.ACTION_INFORMATION5 ) COUNTY_HEAD_TAX_LIABILITY
, TO_NUMBER(COUNTY.ACTION_INFORMATION6 ) COUNTY_HEAD_TAX_WITHHELD
, TO_NUMBER(COUNTY.ACTION_INFORMATION2 ) + TO_NUMBER(COUNTY.ACTION_INFORMATION3 ) COUNTY_SUBJECT
, TO_NUMBER(COUNTY.ACTION_INFORMATION2 ) - TO_NUMBER(COUNTY.ACTION_INFORMATION4 ) COUNTY_REDUCED_SUBJECT
, TO_NUMBER(CITY.ACTION_INFORMATION1) CITY_WITHHELD
, TO_NUMBER(CITY.ACTION_INFORMATION2) CITY_SUBJ_WHABLE
, TO_NUMBER(CITY.ACTION_INFORMATION3) CITY_SUBJ_NWABLE
, TO_NUMBER(CITY.ACTION_INFORMATION4) CITY_PRE_TAX_REDNS
, TO_NUMBER(CITY.ACTION_INFORMATION5) CITY_HEAD_TAX_LIABILITY
, TO_NUMBER(CITY.ACTION_INFORMATION6) CITY_HEAD_TAX_WITHHELD
, TO_NUMBER(CITY.ACTION_INFORMATION2) + TO_NUMBER(CITY.ACTION_INFORMATION3) CITY_SUBJECT
, TO_NUMBER(CITY.ACTION_INFORMATION2) - TO_NUMBER(CITY.ACTION_INFORMATION4) CITY_REDUCED_SUBJECT
, TO_NUMBER(SCHOOL.ACTION_INFORMATION1) SCHOOL_WITHHELD
, TO_NUMBER(SCHOOL.ACTION_INFORMATION2) SCHOOL_SUBJ_WHABLE
, TO_NUMBER(SCHOOL.ACTION_INFORMATION3) SCHOOL_SUBJ_NWHABLE
, TO_NUMBER(SCHOOL.ACTION_INFORMATION4) SCHOOL_PRE_TAX_REDNS
, TO_NUMBER(SCHOOL.ACTION_INFORMATION1) + TO_NUMBER(SCHOOL.ACTION_INFORMATION2) SCHOOL_SUBJECT
, TO_NUMBER(SCHOOL.ACTION_INFORMATION2) - TO_NUMBER(SCHOOL.ACTION_INFORMATION4) SCHOOL_REDUCED_SUBJECT
FROM PAY_ACTION_INFORMATION COUNTY
, PAY_ACTION_INFORMATION CITY
, PAY_ACTION_INFORMATION SCHOOL
, PAY_ASSIGNMENT_ACTIONS ACT
, PER_ALL_ASSIGNMENTS_F ASG
, PER_ALL_PEOPLE_F PER
, PER_BUSINESS_GROUPS BUS
, PAY_PAYROLL_ACTIONS PCT
, HR_ORGANIZATION_UNITS TAX
, PAY_ACTION_INTERLOCKS PLK
, PAY_ASSIGNMENT_ACTIONS PAL
, PAY_PAYROLL_ACTIONS PPL
WHERE COUNTY.ACTION_INFORMATION_CATEGORY = 'US COUNTY'
AND COUNTY.ACTION_CONTEXT_TYPE = 'AAP'
AND CITY.ACTION_INFORMATION_CATEGORY = 'US CITY'
AND CITY.ACTION_CONTEXT_TYPE = 'AAP'
AND SCHOOL.ACTION_INFORMATION_CATEGORY = 'US SCHOOL DISTRICT'
AND SCHOOL.ACTION_CONTEXT_TYPE = 'AAP'
AND ACT.ASSIGNMENT_ACTION_ID = COUNTY.ACTION_CONTEXT_ID
AND ACT.ASSIGNMENT_ACTION_ID = CITY.ACTION_CONTEXT_ID
AND ACT.ASSIGNMENT_ACTION_ID = SCHOOL.ACTION_CONTEXT_ID
AND ACT.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND ACT.PAYROLL_ACTION_ID = PCT.PAYROLL_ACTION_ID
AND ASG.PERSON_ID = PER.PERSON_ID
AND ASG.EFFECTIVE_START_DATE = ( SELECT MAX(PAF.EFFECTIVE_START_DATE)
FROM PER_ASSIGNMENTS_F PAF
WHERE PAF.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND PAF.EFFECTIVE_START_DATE <= PCT.EFFECTIVE_DATE )
AND PCT.EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND BUS.BUSINESS_GROUP_ID = ASG.BUSINESS_GROUP_ID
AND TAX.ORGANIZATION_ID = CITY.TAX_UNIT_ID
AND PLK.LOCKING_ACTION_ID = ACT.ASSIGNMENT_ACTION_ID
AND PLK.LOCKED_ACTION_ID = PAL.ASSIGNMENT_ACTION_ID
AND PAL.PAYROLL_ACTION_ID = PPL.PAYROLL_ACTION_ID

Columns