VIEW: APPS.BEN_ASSIGNMENT_EXTRA_IN_V

Source

View Text - Preformatted

SELECT asg.ROWID ROW_ID, asg.ASSIGNMENT_ID, asg.EFFECTIVE_START_DATE, asg.EFFECTIVE_END_DATE, asg.BUSINESS_GROUP_ID, asg.RECRUITER_ID, asg.GRADE_ID, asg.POSITION_ID, asg.JOB_ID, asg.ASSIGNMENT_STATUS_TYPE_ID, asg.PAYROLL_ID, asg.LOCATION_ID, asg.PERSON_REFERRED_BY_ID, asg.SUPERVISOR_ID, asg.SPECIAL_CEILING_STEP_ID, asg.PERSON_ID, asg.RECRUITMENT_ACTIVITY_ID, asg.SOURCE_ORGANIZATION_ID, asg.ORGANIZATION_ID, asg.PEOPLE_GROUP_ID, asg.SOFT_CODING_KEYFLEX_ID, asg.VACANCY_ID, asg.PAY_BASIS_ID, asg.ASSIGNMENT_SEQUENCE, asg.ASSIGNMENT_TYPE, asg.PRIMARY_FLAG, asg.APPLICATION_ID , asg.ASSIGNMENT_NUMBER, asg.CHANGE_REASON, asg.COMMENT_ID, asg.DATE_PROBATION_END, asg.DEFAULT_CODE_COMB_ID, asg.EMPLOYMENT_CATEGORY, asg.FREQUENCY, asg.INTERNAL_ADDRESS_LINE, asg.MANAGER_FLAG, asg.NORMAL_HOURS, asg.PERF_REVIEW_PERIOD, asg.PERF_REVIEW_PERIOD_FREQUENCY, asg.PERIOD_OF_SERVICE_ID, asg.PROBATION_PERIOD, asg.PROBATION_UNIT, asg.SAL_REVIEW_PERIOD, asg.SAL_REVIEW_PERIOD_FREQUENCY, asg.SET_OF_BOOKS_ID, asg.SOURCE_TYPE, asg.TIME_NORMAL_FINISH, asg.TIME_NORMAL_START, asg.BARGAINING_UNIT_CODE, asg.LABOUR_UNION_MEMBER_FLAG , asg.HOURLY_SALARIED_CODE, asg.TITLE , asg.ASS_ATTRIBUTE_CATEGORY , asg.ASS_ATTRIBUTE1 , asg.ASS_ATTRIBUTE2 , asg.ASS_ATTRIBUTE3 , asg.ASS_ATTRIBUTE4 , asg.ASS_ATTRIBUTE5 , asg.ASS_ATTRIBUTE6 , asg.ASS_ATTRIBUTE7 , asg.ASS_ATTRIBUTE8 , asg.ASS_ATTRIBUTE9 , asg.ASS_ATTRIBUTE10 , asg.ASS_ATTRIBUTE11 , asg.ASS_ATTRIBUTE12 , asg.ASS_ATTRIBUTE13 , asg.ASS_ATTRIBUTE14 , asg.ASS_ATTRIBUTE15 , asg.ASS_ATTRIBUTE16 , asg.ASS_ATTRIBUTE17 , asg.ASS_ATTRIBUTE18 , asg.ASS_ATTRIBUTE19 , asg.ASS_ATTRIBUTE20, asg.ASS_ATTRIBUTE21 , asg.ASS_ATTRIBUTE22, asg.ASS_ATTRIBUTE23, asg.ASS_ATTRIBUTE24, asg.ASS_ATTRIBUTE25, asg.ASS_ATTRIBUTE26, asg.ASS_ATTRIBUTE27, asg.ASS_ATTRIBUTE28, asg.ASS_ATTRIBUTE29, asg.ASS_ATTRIBUTE30 , aei.ASSIGNMENT_EXTRA_INFO_ID , aei.INFORMATION_TYPE , asg.REQUEST_ID , asg.PROGRAM_APPLICATION_ID , asg.PROGRAM_ID , asg.PROGRAM_UPDATE_DATE , aei.AEI_ATTRIBUTE_CATEGORY , aei.AEI_ATTRIBUTE1 , aei.AEI_ATTRIBUTE2 , aei.AEI_ATTRIBUTE3 , aei.AEI_ATTRIBUTE4 , aei.AEI_ATTRIBUTE5 , aei.AEI_ATTRIBUTE6 , aei.AEI_ATTRIBUTE7 , aei.AEI_ATTRIBUTE8 , aei.AEI_ATTRIBUTE9 , aei.AEI_ATTRIBUTE10 , aei.AEI_ATTRIBUTE11 , aei.AEI_ATTRIBUTE12 , aei.AEI_ATTRIBUTE13 , aei.AEI_ATTRIBUTE14 , aei.AEI_ATTRIBUTE15 , aei.AEI_ATTRIBUTE16 , aei.AEI_ATTRIBUTE17 , aei.AEI_ATTRIBUTE18 , aei.AEI_ATTRIBUTE19 , aei.AEI_ATTRIBUTE20 , aei.AEI_INFORMATION_CATEGORY , aei.AEI_INFORMATION1 , aei.AEI_INFORMATION2 , aei.AEI_INFORMATION3 , aei.AEI_INFORMATION4 , aei.AEI_INFORMATION5 , aei.AEI_INFORMATION6 , aei.AEI_INFORMATION7 , aei.AEI_INFORMATION8 , aei.AEI_INFORMATION9 , aei.AEI_INFORMATION10 , aei.AEI_INFORMATION11 , aei.AEI_INFORMATION12 , aei.AEI_INFORMATION13 , aei.AEI_INFORMATION14 , aei.AEI_INFORMATION15 , aei.AEI_INFORMATION16 , aei.AEI_INFORMATION17 , aei.AEI_INFORMATION18 , aei.AEI_INFORMATION19 , aei.AEI_INFORMATION20 , aei.AEI_INFORMATION21 , aei.AEI_INFORMATION22 , aei.AEI_INFORMATION23 , aei.AEI_INFORMATION24 , aei.AEI_INFORMATION25 , aei.AEI_INFORMATION26 , aei.AEI_INFORMATION27 , aei.AEI_INFORMATION28 , aei.AEI_INFORMATION29 , aei.AEI_INFORMATION30 , aei.LAST_UPDATE_DATE , asg.OBJECT_VERSION_NUMBER , asg.LAST_UPDATED_BY , asg.LAST_UPDATE_LOGIN , asg.CREATED_BY , asg.CREATION_DATE from PER_ASSIGNMENT_EXTRA_INFO aei,PER_ALL_ASSIGNMENTS_F asg, fnd_sessions se WHERE aei.assignment_id(+) = asg.assignment_id and se.session_id = userenv('sessionid') AND SE.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT ASG.ROWID ROW_ID
, ASG.ASSIGNMENT_ID
, ASG.EFFECTIVE_START_DATE
, ASG.EFFECTIVE_END_DATE
, ASG.BUSINESS_GROUP_ID
, ASG.RECRUITER_ID
, ASG.GRADE_ID
, ASG.POSITION_ID
, ASG.JOB_ID
, ASG.ASSIGNMENT_STATUS_TYPE_ID
, ASG.PAYROLL_ID
, ASG.LOCATION_ID
, ASG.PERSON_REFERRED_BY_ID
, ASG.SUPERVISOR_ID
, ASG.SPECIAL_CEILING_STEP_ID
, ASG.PERSON_ID
, ASG.RECRUITMENT_ACTIVITY_ID
, ASG.SOURCE_ORGANIZATION_ID
, ASG.ORGANIZATION_ID
, ASG.PEOPLE_GROUP_ID
, ASG.SOFT_CODING_KEYFLEX_ID
, ASG.VACANCY_ID
, ASG.PAY_BASIS_ID
, ASG.ASSIGNMENT_SEQUENCE
, ASG.ASSIGNMENT_TYPE
, ASG.PRIMARY_FLAG
, ASG.APPLICATION_ID
, ASG.ASSIGNMENT_NUMBER
, ASG.CHANGE_REASON
, ASG.COMMENT_ID
, ASG.DATE_PROBATION_END
, ASG.DEFAULT_CODE_COMB_ID
, ASG.EMPLOYMENT_CATEGORY
, ASG.FREQUENCY
, ASG.INTERNAL_ADDRESS_LINE
, ASG.MANAGER_FLAG
, ASG.NORMAL_HOURS
, ASG.PERF_REVIEW_PERIOD
, ASG.PERF_REVIEW_PERIOD_FREQUENCY
, ASG.PERIOD_OF_SERVICE_ID
, ASG.PROBATION_PERIOD
, ASG.PROBATION_UNIT
, ASG.SAL_REVIEW_PERIOD
, ASG.SAL_REVIEW_PERIOD_FREQUENCY
, ASG.SET_OF_BOOKS_ID
, ASG.SOURCE_TYPE
, ASG.TIME_NORMAL_FINISH
, ASG.TIME_NORMAL_START
, ASG.BARGAINING_UNIT_CODE
, ASG.LABOUR_UNION_MEMBER_FLAG
, ASG.HOURLY_SALARIED_CODE
, ASG.TITLE
, ASG.ASS_ATTRIBUTE_CATEGORY
, ASG.ASS_ATTRIBUTE1
, ASG.ASS_ATTRIBUTE2
, ASG.ASS_ATTRIBUTE3
, ASG.ASS_ATTRIBUTE4
, ASG.ASS_ATTRIBUTE5
, ASG.ASS_ATTRIBUTE6
, ASG.ASS_ATTRIBUTE7
, ASG.ASS_ATTRIBUTE8
, ASG.ASS_ATTRIBUTE9
, ASG.ASS_ATTRIBUTE10
, ASG.ASS_ATTRIBUTE11
, ASG.ASS_ATTRIBUTE12
, ASG.ASS_ATTRIBUTE13
, ASG.ASS_ATTRIBUTE14
, ASG.ASS_ATTRIBUTE15
, ASG.ASS_ATTRIBUTE16
, ASG.ASS_ATTRIBUTE17
, ASG.ASS_ATTRIBUTE18
, ASG.ASS_ATTRIBUTE19
, ASG.ASS_ATTRIBUTE20
, ASG.ASS_ATTRIBUTE21
, ASG.ASS_ATTRIBUTE22
, ASG.ASS_ATTRIBUTE23
, ASG.ASS_ATTRIBUTE24
, ASG.ASS_ATTRIBUTE25
, ASG.ASS_ATTRIBUTE26
, ASG.ASS_ATTRIBUTE27
, ASG.ASS_ATTRIBUTE28
, ASG.ASS_ATTRIBUTE29
, ASG.ASS_ATTRIBUTE30
, AEI.ASSIGNMENT_EXTRA_INFO_ID
, AEI.INFORMATION_TYPE
, ASG.REQUEST_ID
, ASG.PROGRAM_APPLICATION_ID
, ASG.PROGRAM_ID
, ASG.PROGRAM_UPDATE_DATE
, AEI.AEI_ATTRIBUTE_CATEGORY
, AEI.AEI_ATTRIBUTE1
, AEI.AEI_ATTRIBUTE2
, AEI.AEI_ATTRIBUTE3
, AEI.AEI_ATTRIBUTE4
, AEI.AEI_ATTRIBUTE5
, AEI.AEI_ATTRIBUTE6
, AEI.AEI_ATTRIBUTE7
, AEI.AEI_ATTRIBUTE8
, AEI.AEI_ATTRIBUTE9
, AEI.AEI_ATTRIBUTE10
, AEI.AEI_ATTRIBUTE11
, AEI.AEI_ATTRIBUTE12
, AEI.AEI_ATTRIBUTE13
, AEI.AEI_ATTRIBUTE14
, AEI.AEI_ATTRIBUTE15
, AEI.AEI_ATTRIBUTE16
, AEI.AEI_ATTRIBUTE17
, AEI.AEI_ATTRIBUTE18
, AEI.AEI_ATTRIBUTE19
, AEI.AEI_ATTRIBUTE20
, AEI.AEI_INFORMATION_CATEGORY
, AEI.AEI_INFORMATION1
, AEI.AEI_INFORMATION2
, AEI.AEI_INFORMATION3
, AEI.AEI_INFORMATION4
, AEI.AEI_INFORMATION5
, AEI.AEI_INFORMATION6
, AEI.AEI_INFORMATION7
, AEI.AEI_INFORMATION8
, AEI.AEI_INFORMATION9
, AEI.AEI_INFORMATION10
, AEI.AEI_INFORMATION11
, AEI.AEI_INFORMATION12
, AEI.AEI_INFORMATION13
, AEI.AEI_INFORMATION14
, AEI.AEI_INFORMATION15
, AEI.AEI_INFORMATION16
, AEI.AEI_INFORMATION17
, AEI.AEI_INFORMATION18
, AEI.AEI_INFORMATION19
, AEI.AEI_INFORMATION20
, AEI.AEI_INFORMATION21
, AEI.AEI_INFORMATION22
, AEI.AEI_INFORMATION23
, AEI.AEI_INFORMATION24
, AEI.AEI_INFORMATION25
, AEI.AEI_INFORMATION26
, AEI.AEI_INFORMATION27
, AEI.AEI_INFORMATION28
, AEI.AEI_INFORMATION29
, AEI.AEI_INFORMATION30
, AEI.LAST_UPDATE_DATE
, ASG.OBJECT_VERSION_NUMBER
, ASG.LAST_UPDATED_BY
, ASG.LAST_UPDATE_LOGIN
, ASG.CREATED_BY
, ASG.CREATION_DATE
FROM PER_ASSIGNMENT_EXTRA_INFO AEI
, PER_ALL_ASSIGNMENTS_F ASG
, FND_SESSIONS SE
WHERE AEI.ASSIGNMENT_ID(+) = ASG.ASSIGNMENT_ID
AND SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE