HXT Person/Assignment Table List
Description
Categories: BI Publisher
Application: Time and Labor
Source: Person/Assignment Table List (XML)
Short Name: HXT957I_XML
DB package: HXT_HXT957I_XMLP_PKG
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 |