SELECT ASS.ROWID , PER.PERSON_ID , PER.FULL_NAME , ASS.ASSIGNMENT_ID , ASS.ASSIGNMENT_NUMBER , ASS.EFFECTIVE_START_DATE , ASS.EFFECTIVE_END_DATE , ASS.BUSINESS_GROUP_ID + 0 , ASS.PAYROLL_ID , TUTL.NAME , TU.ORGANIZATION_ID FROM HR_ALL_ORGANIZATION_UNITS_TL TUTL , HR_ALL_ORGANIZATION_UNITS TU , HR_SOFT_CODING_KEYFLEX SCL , PAY_ALL_PAYROLLS_F PAY , PER_ALL_ASSIGNMENTS_F ASS , PER_PEOPLE_F PER , FND_SESSIONS SES WHERE TU.ORGANIZATION_ID = TUTL.ORGANIZATION_ID AND TUTL.LANGUAGE = USERENV('LANG') AND TU.ORGANIZATION_ID = SCL.SEGMENT1 AND SCL.SOFT_CODING_KEYFLEX_ID = ASS.SOFT_CODING_KEYFLEX_ID AND ASS.PAYROLL_ID IS NOT NULL AND SES.EFFECTIVE_DATE BETWEEN PAY.EFFECTIVE_START_DATE AND PAY.EFFECTIVE_END_DATE AND ASS.PAYROLL_ID = PAY.PAYROLL_ID AND SES.EFFECTIVE_DATE BETWEEN ASS.EFFECTIVE_START_DATE AND ASS.EFFECTIVE_END_DATE AND ASS.PERSON_ID = PER.PERSON_ID AND SES.EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE AND PER.EFFECTIVE_END_DATE AND SES.SESSION_ID = USERENV('SESSIONID')