HXT Person/Assignment Table List

Description
Categories: BI Publisher, Human Resources
Application: Time and Labor
Source: Person/Assignment Table List (XML)
Short Name: HXT957I_XML
DB package: HXT_HXT957I_XMLP_PKG
select ASS.PERSON_ID PERSON_ID2 , STA.USER_STATUS, ASS.EFFECTIVE_START_DATE, ASS.EFFECTIVE_END_DATE, ASS.ASSIGNMENT_NUMBER, PAY.PAYROLL_ID, AEIV.HXT_AUTOGEN_HOURS_YN, PAY.PAYROLL_NAME, AEIV.HXT_EARNING_POLICY, AEIV.HXT_SHIFT_DIFFERENTIAL_POLICY, AEIV.HXT_HOUR_DEDUCTION_POLICY, AEIV.HXT_ROTATION_PLAN
from PER_ASSIGNMENTS_F ASS, HXT_PER_AEI_DDF_V AEIV, PER_ASSIGNMENT_STATUS_TYPES STA, PAY_PAYROLLS_F PAY
where ASS.ASSIGNMENT_STATUS_TYPE_ID = STA.ASSIGNMENT_STATUS_TYPE_ID
AND ASS.PAYROLL_ID = PAY.PAYROLL_ID
AND ASS.ASSIGNMENT_ID = AEIV.ASSIGNMENT_ID
AND ASS.EFFECTIVE_END_DATE BETWEEN PAY.EFFECTIVE_START_DATE AND PAY.EFFECTIVE_END_DATE 
 and ASS.PERSON_ID=:PERSON_ID_1