View: BEN_ASSIGNMENT_EXTRA_IN_V

Product:	BEN - Advanced Benefits
Description:
Implementation/DBA Data:	APPS.BEN_ASSIGNMENT_EXTRA_IN_V

View Text

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

Columns