eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HR_EMPLOYEE_API_V

Source

View Text - Preformatted


SELECT PER.PERSON_ID,PER.EFFECTIVE_START_DATE,PER.EFFECTIVE_END_DATE,PER.BUSINESS_GROUP_ID,PER.PERSON_TYPE_ID,PER.LAST_NAME,PER.START_DATE,PER.APPLICANT_NUMBER,PER.BACKGROUND_CHECK_STATUS,PER.BACKGROUND_DATE_CHECK,PER.BLOOD_TYPE,PER.COMMENT_ID,PER.CORRESPONDENCE_LANGUAGE,PER.CURRENT_APPLICANT_FLAG,PER.CURRENT_EMP_OR_APL_FLAG,PER.CURRENT_EMPLOYEE_FLAG,PER.DATE_EMPLOYEE_DATA_VERIFIED,PER.DATE_OF_BIRTH,PER.EMAIL_ADDRESS,PER.EMPLOYEE_NUMBER,PER.EXPENSE_CHECK_SEND_TO_ADDRESS,PER.FAST_PATH_EMPLOYEE,PER.FIRST_NAME,PER.FTE_CAPACITY,PER.FULL_NAME,PER.HOLD_APPLICANT_DATE_UNTIL,PER.HONORS,PER.INTERNAL_LOCATION,PER.KNOWN_AS,PER.LAST_MEDICAL_TEST_BY,PER.LAST_MEDICAL_TEST_DATE,PER.MAILSTOP,PER.MARITAL_STATUS,PER.MIDDLE_NAMES,PER.NATIONALITY,PER.NATIONAL_IDENTIFIER,PER.OFFICE_NUMBER,PER.ON_MILITARY_SERVICE,PER.ORDER_NAME,PER.PRE_NAME_ADJUNCT,PER.PREVIOUS_LAST_NAME,PER.PROJECTED_START_DATE,PER.REHIRE_AUTHORIZOR,PER.REHIRE_REASON,PER.REHIRE_RECOMMENDATION,PER.RESUME_EXISTS,PER.RESUME_LAST_UPDATED,PER.REGISTERED_DISABLED_FLAG,PER.SECOND_PASSPORT_EXISTS,PER.SEX,PER.STUDENT_STATUS,PER.SUFFIX,PER.TITLE,PER.VENDOR_ID,PER.WORK_SCHEDULE,PER.WORK_TELEPHONE,PER.COORD_BEN_MED_PLN_NO,PER.COORD_BEN_NO_CVG_FLAG,PER.DPDNT_ADOPTION_DATE,PER.DPDNT_VLNTRY_SVCE_FLAG,PER.RECEIPT_OF_DEATH_CERT_DATE,PER.USES_TOBACCO_FLAG,PER.BENEFIT_GROUP_ID,PER.REQUEST_ID,PER.ATTRIBUTE_CATEGORY,PER.ATTRIBUTE1,PER.ATTRIBUTE2,PER.ATTRIBUTE3,PER.ATTRIBUTE4,PER.ATTRIBUTE5,PER.ATTRIBUTE6,PER.ATTRIBUTE7,PER.ATTRIBUTE8,PER.ATTRIBUTE9,PER.ATTRIBUTE10,PER.ATTRIBUTE11,PER.ATTRIBUTE12,PER.ATTRIBUTE13,PER.ATTRIBUTE14,PER.ATTRIBUTE15,PER.ATTRIBUTE16,PER.ATTRIBUTE17,PER.ATTRIBUTE18,PER.ATTRIBUTE19,PER.ATTRIBUTE20,PER.ATTRIBUTE21,PER.ATTRIBUTE22,PER.ATTRIBUTE23,PER.ATTRIBUTE24,PER.ATTRIBUTE25,PER.ATTRIBUTE26,PER.ATTRIBUTE27,PER.ATTRIBUTE28,PER.ATTRIBUTE29,PER.ATTRIBUTE30,PER.PER_INFORMATION_CATEGORY,PER.PER_INFORMATION1,PER.PER_INFORMATION2,PER.PER_INFORMATION3,PER.PER_INFORMATION4,PER.PER_INFORMATION5,PER.PER_INFORMATION6,PER.PER_INFORMATION7,PER.PER_INFORMATION8,PER.PER_INFORMATION9,PER.PER_INFORMATION10,PER.PER_INFORMATION11,PER.PER_INFORMATION12,PER.PER_INFORMATION13,PER.PER_INFORMATION14,PER.PER_INFORMATION15,PER.PER_INFORMATION16,PER.PER_INFORMATION17,PER.PER_INFORMATION18,PER.PER_INFORMATION19,PER.PER_INFORMATION20,PER.PER_INFORMATION21,PER.PER_INFORMATION22,PER.PER_INFORMATION23,PER.PER_INFORMATION24,PER.PER_INFORMATION25,PER.PER_INFORMATION26,PER.PER_INFORMATION27,PER.PER_INFORMATION28,PER.PER_INFORMATION29,PER.PER_INFORMATION30,PER.OBJECT_VERSION_NUMBER,PER.DATE_OF_DEATH,PER.ORIGINAL_DATE_OF_HIRE,PER.TOWN_OF_BIRTH,PER.REGION_OF_BIRTH,PER.COUNTRY_OF_BIRTH,PER.GLOBAL_PERSON_ID,PER.COORD_BEN_MED_PL_NAME,PER.COORD_BEN_MED_INSR_CRR_NAME,PER.COORD_BEN_MED_INSR_CRR_IDENT,PER.COORD_BEN_MED_EXT_ER,PER.COORD_BEN_MED_CVG_STRT_DT,PER.COORD_BEN_MED_CVG_END_DT,PER.PARTY_ID,PER.NPW_NUMBER,PER.CURRENT_NPW_FLAG,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.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.CONTRACT_ID,ASG.COLLECTIVE_AGREEMENT_ID,ASG.CAGR_ID_FLEX_NUM,ASG.CAGR_GRADE_DEF_ID,ASG.ESTABLISHMENT_ID,ASG.REQUEST_ID,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,ASG.TITLE,ASG.OBJECT_VERSION_NUMBER,ASG.NOTICE_PERIOD,ASG.NOTICE_PERIOD_UOM,ASG.EMPLOYEE_CATEGORY,ASG.WORK_AT_HOME,ASG.JOB_POST_SOURCE_NAME,ASG.POSTING_CONTENT_ID,ASG.PERIOD_OF_PLACEMENT_DATE_START,ASG.VENDOR_ID,ASG.VENDOR_EMPLOYEE_NUMBER,ASG.VENDOR_ASSIGNMENT_NUMBER,ASG.ASSIGNMENT_CATEGORY,ASG.PROJECT_TITLE,POS.PERIOD_OF_SERVICE_ID,POS.BUSINESS_GROUP_ID,POS.TERMINATION_ACCEPTED_PERSON_ID,POS.PERSON_ID,POS.DATE_START,POS.ACCEPTED_TERMINATION_DATE,POS.ACTUAL_TERMINATION_DATE,POS.COMMENTS,POS.FINAL_PROCESS_DATE,POS.LAST_STANDARD_PROCESS_DATE,POS.LEAVING_REASON,POS.NOTIFIED_TERMINATION_DATE,POS.PROJECTED_TERMINATION_DATE,POS.ADJUSTED_SVC_DATE,POS.REQUEST_ID,POS.ATTRIBUTE_CATEGORY,POS.ATTRIBUTE1,POS.ATTRIBUTE2,POS.ATTRIBUTE3,POS.ATTRIBUTE4,POS.ATTRIBUTE5,POS.ATTRIBUTE6,POS.ATTRIBUTE7,POS.ATTRIBUTE8,POS.ATTRIBUTE9,POS.ATTRIBUTE10,POS.ATTRIBUTE11,POS.ATTRIBUTE12,POS.ATTRIBUTE13,POS.ATTRIBUTE14,POS.ATTRIBUTE15,POS.ATTRIBUTE16,POS.ATTRIBUTE17,POS.ATTRIBUTE18,POS.ATTRIBUTE19,POS.ATTRIBUTE20,POS.OBJECT_VERSION_NUMBER,POS.PRIOR_EMPLOYMENT_SSP_PAID_TO,POS.PRIOR_EMPLOYMENT_SSP_WEEKS,POS.PDS_INFORMATION_CATEGORY,POS.PDS_INFORMATION1,POS.PDS_INFORMATION2,POS.PDS_INFORMATION3,POS.PDS_INFORMATION4,POS.PDS_INFORMATION5,POS.PDS_INFORMATION6,POS.PDS_INFORMATION7,POS.PDS_INFORMATION8,POS.PDS_INFORMATION9,POS.PDS_INFORMATION10,POS.PDS_INFORMATION11,POS.PDS_INFORMATION12,POS.PDS_INFORMATION13,POS.PDS_INFORMATION14,POS.PDS_INFORMATION15,POS.PDS_INFORMATION16,POS.PDS_INFORMATION17,POS.PDS_INFORMATION18,POS.PDS_INFORMATION19,POS.PDS_INFORMATION20,POS.PDS_INFORMATION21,POS.PDS_INFORMATION22,POS.PDS_INFORMATION23,POS.PDS_INFORMATION24,POS.PDS_INFORMATION25,POS.PDS_INFORMATION26,POS.PDS_INFORMATION27,POS.PDS_INFORMATION28,POS.PDS_INFORMATION29,POS.PDS_INFORMATION30,ADDR.ADDRESS_ID,ADDR.BUSINESS_GROUP_ID,ADDR.PERSON_ID,ADDR.DATE_FROM,ADDR.PRIMARY_FLAG,ADDR.STYLE,ADDR.ADDRESS_LINE1,ADDR.ADDRESS_LINE2,ADDR.ADDRESS_LINE3,ADDR.ADDRESS_TYPE,ADDR.COMMENTS,ADDR.COUNTRY,ADDR.DATE_TO,ADDR.POSTAL_CODE,ADDR.REGION_1,ADDR.REGION_2,ADDR.REGION_3,ADDR.TELEPHONE_NUMBER_1,ADDR.TELEPHONE_NUMBER_2,ADDR.TELEPHONE_NUMBER_3,ADDR.TOWN_OR_CITY,ADDR.REQUEST_ID,ADDR.PROGRAM_APPLICATION_ID,ADDR.PROGRAM_ID,ADDR.PROGRAM_UPDATE_DATE,ADDR.ADDR_ATTRIBUTE_CATEGORY,ADDR.ADDR_ATTRIBUTE1,ADDR.ADDR_ATTRIBUTE2,ADDR.ADDR_ATTRIBUTE3,ADDR.ADDR_ATTRIBUTE4,ADDR.ADDR_ATTRIBUTE5,ADDR.ADDR_ATTRIBUTE6,ADDR.ADDR_ATTRIBUTE7,ADDR.ADDR_ATTRIBUTE8,ADDR.ADDR_ATTRIBUTE9,ADDR.ADDR_ATTRIBUTE10,ADDR.ADDR_ATTRIBUTE11,ADDR.ADDR_ATTRIBUTE12,ADDR.ADDR_ATTRIBUTE13,ADDR.ADDR_ATTRIBUTE14,ADDR.ADDR_ATTRIBUTE15,ADDR.ADDR_ATTRIBUTE16,ADDR.ADDR_ATTRIBUTE17,ADDR.ADDR_ATTRIBUTE18,ADDR.ADDR_ATTRIBUTE19,ADDR.ADDR_ATTRIBUTE20,ADDR.LAST_UPDATE_DATE,ADDR.LAST_UPDATED_BY,ADDR.LAST_UPDATE_LOGIN,ADDR.CREATED_BY,ADDR.CREATION_DATE,ADDR.OBJECT_VERSION_NUMBER,ADDR.ADD_INFORMATION13,ADDR.ADD_INFORMATION14,ADDR.ADD_INFORMATION15,ADDR.ADD_INFORMATION16,ADDR.ADD_INFORMATION17,ADDR.ADD_INFORMATION18,ADDR.ADD_INFORMATION19,ADDR.ADD_INFORMATION20,ADDR.PARTY_ID,ADDR.DERIVED_LOCALE FROM PER_ALL_PEOPLE_F PER,PER_ALL_ASSIGNMENTS_F ASG,PER_PERIODS_OF_SERVICE POS,PER_PERSON_TYPES PPT,PER_ADDRESSES ADDR WHERE per.person_id = asg.person_id and ( per.effective_start_date between asg.effective_start_date and asg.effective_end_date or asg.effective_start_date between per.effective_start_date and per.effective_end_date ) and pos.person_id = per.person_id and per.person_type_id = ppt.person_type_id and ppt.system_person_type = 'EMP' and per.business_group_id = ppt.business_group_id and asg.primary_flag = 'Y' and per.effective_start_date between pos.date_start and nvl(actual_termination_date,per.effective_start_date) and per.person_id = addr.person_id(+)

View Text - HTML Formatted

SELECT PER.PERSON_ID
, PER.EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE
, PER.BUSINESS_GROUP_ID
, PER.PERSON_TYPE_ID
, PER.LAST_NAME
, PER.START_DATE
, PER.APPLICANT_NUMBER
, PER.BACKGROUND_CHECK_STATUS
, PER.BACKGROUND_DATE_CHECK
, PER.BLOOD_TYPE
, PER.COMMENT_ID
, PER.CORRESPONDENCE_LANGUAGE
, PER.CURRENT_APPLICANT_FLAG
, PER.CURRENT_EMP_OR_APL_FLAG
, PER.CURRENT_EMPLOYEE_FLAG
, PER.DATE_EMPLOYEE_DATA_VERIFIED
, PER.DATE_OF_BIRTH
, PER.EMAIL_ADDRESS
, PER.EMPLOYEE_NUMBER
, PER.EXPENSE_CHECK_SEND_TO_ADDRESS
, PER.FAST_PATH_EMPLOYEE
, PER.FIRST_NAME
, PER.FTE_CAPACITY
, PER.FULL_NAME
, PER.HOLD_APPLICANT_DATE_UNTIL
, PER.HONORS
, PER.INTERNAL_LOCATION
, PER.KNOWN_AS
, PER.LAST_MEDICAL_TEST_BY
, PER.LAST_MEDICAL_TEST_DATE
, PER.MAILSTOP
, PER.MARITAL_STATUS
, PER.MIDDLE_NAMES
, PER.NATIONALITY
, PER.NATIONAL_IDENTIFIER
, PER.OFFICE_NUMBER
, PER.ON_MILITARY_SERVICE
, PER.ORDER_NAME
, PER.PRE_NAME_ADJUNCT
, PER.PREVIOUS_LAST_NAME
, PER.PROJECTED_START_DATE
, PER.REHIRE_AUTHORIZOR
, PER.REHIRE_REASON
, PER.REHIRE_RECOMMENDATION
, PER.RESUME_EXISTS
, PER.RESUME_LAST_UPDATED
, PER.REGISTERED_DISABLED_FLAG
, PER.SECOND_PASSPORT_EXISTS
, PER.SEX
, PER.STUDENT_STATUS
, PER.SUFFIX
, PER.TITLE
, PER.VENDOR_ID
, PER.WORK_SCHEDULE
, PER.WORK_TELEPHONE
, PER.COORD_BEN_MED_PLN_NO
, PER.COORD_BEN_NO_CVG_FLAG
, PER.DPDNT_ADOPTION_DATE
, PER.DPDNT_VLNTRY_SVCE_FLAG
, PER.RECEIPT_OF_DEATH_CERT_DATE
, PER.USES_TOBACCO_FLAG
, PER.BENEFIT_GROUP_ID
, PER.REQUEST_ID
, PER.ATTRIBUTE_CATEGORY
, PER.ATTRIBUTE1
, PER.ATTRIBUTE2
, PER.ATTRIBUTE3
, PER.ATTRIBUTE4
, PER.ATTRIBUTE5
, PER.ATTRIBUTE6
, PER.ATTRIBUTE7
, PER.ATTRIBUTE8
, PER.ATTRIBUTE9
, PER.ATTRIBUTE10
, PER.ATTRIBUTE11
, PER.ATTRIBUTE12
, PER.ATTRIBUTE13
, PER.ATTRIBUTE14
, PER.ATTRIBUTE15
, PER.ATTRIBUTE16
, PER.ATTRIBUTE17
, PER.ATTRIBUTE18
, PER.ATTRIBUTE19
, PER.ATTRIBUTE20
, PER.ATTRIBUTE21
, PER.ATTRIBUTE22
, PER.ATTRIBUTE23
, PER.ATTRIBUTE24
, PER.ATTRIBUTE25
, PER.ATTRIBUTE26
, PER.ATTRIBUTE27
, PER.ATTRIBUTE28
, PER.ATTRIBUTE29
, PER.ATTRIBUTE30
, PER.PER_INFORMATION_CATEGORY
, PER.PER_INFORMATION1
, PER.PER_INFORMATION2
, PER.PER_INFORMATION3
, PER.PER_INFORMATION4
, PER.PER_INFORMATION5
, PER.PER_INFORMATION6
, PER.PER_INFORMATION7
, PER.PER_INFORMATION8
, PER.PER_INFORMATION9
, PER.PER_INFORMATION10
, PER.PER_INFORMATION11
, PER.PER_INFORMATION12
, PER.PER_INFORMATION13
, PER.PER_INFORMATION14
, PER.PER_INFORMATION15
, PER.PER_INFORMATION16
, PER.PER_INFORMATION17
, PER.PER_INFORMATION18
, PER.PER_INFORMATION19
, PER.PER_INFORMATION20
, PER.PER_INFORMATION21
, PER.PER_INFORMATION22
, PER.PER_INFORMATION23
, PER.PER_INFORMATION24
, PER.PER_INFORMATION25
, PER.PER_INFORMATION26
, PER.PER_INFORMATION27
, PER.PER_INFORMATION28
, PER.PER_INFORMATION29
, PER.PER_INFORMATION30
, PER.OBJECT_VERSION_NUMBER
, PER.DATE_OF_DEATH
, PER.ORIGINAL_DATE_OF_HIRE
, PER.TOWN_OF_BIRTH
, PER.REGION_OF_BIRTH
, PER.COUNTRY_OF_BIRTH
, PER.GLOBAL_PERSON_ID
, PER.COORD_BEN_MED_PL_NAME
, PER.COORD_BEN_MED_INSR_CRR_NAME
, PER.COORD_BEN_MED_INSR_CRR_IDENT
, PER.COORD_BEN_MED_EXT_ER
, PER.COORD_BEN_MED_CVG_STRT_DT
, PER.COORD_BEN_MED_CVG_END_DT
, PER.PARTY_ID
, PER.NPW_NUMBER
, PER.CURRENT_NPW_FLAG
, 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.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.CONTRACT_ID
, ASG.COLLECTIVE_AGREEMENT_ID
, ASG.CAGR_ID_FLEX_NUM
, ASG.CAGR_GRADE_DEF_ID
, ASG.ESTABLISHMENT_ID
, ASG.REQUEST_ID
, 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
, ASG.TITLE
, ASG.OBJECT_VERSION_NUMBER
, ASG.NOTICE_PERIOD
, ASG.NOTICE_PERIOD_UOM
, ASG.EMPLOYEE_CATEGORY
, ASG.WORK_AT_HOME
, ASG.JOB_POST_SOURCE_NAME
, ASG.POSTING_CONTENT_ID
, ASG.PERIOD_OF_PLACEMENT_DATE_START
, ASG.VENDOR_ID
, ASG.VENDOR_EMPLOYEE_NUMBER
, ASG.VENDOR_ASSIGNMENT_NUMBER
, ASG.ASSIGNMENT_CATEGORY
, ASG.PROJECT_TITLE
, POS.PERIOD_OF_SERVICE_ID
, POS.BUSINESS_GROUP_ID
, POS.TERMINATION_ACCEPTED_PERSON_ID
, POS.PERSON_ID
, POS.DATE_START
, POS.ACCEPTED_TERMINATION_DATE
, POS.ACTUAL_TERMINATION_DATE
, POS.COMMENTS
, POS.FINAL_PROCESS_DATE
, POS.LAST_STANDARD_PROCESS_DATE
, POS.LEAVING_REASON
, POS.NOTIFIED_TERMINATION_DATE
, POS.PROJECTED_TERMINATION_DATE
, POS.ADJUSTED_SVC_DATE
, POS.REQUEST_ID
, POS.ATTRIBUTE_CATEGORY
, POS.ATTRIBUTE1
, POS.ATTRIBUTE2
, POS.ATTRIBUTE3
, POS.ATTRIBUTE4
, POS.ATTRIBUTE5
, POS.ATTRIBUTE6
, POS.ATTRIBUTE7
, POS.ATTRIBUTE8
, POS.ATTRIBUTE9
, POS.ATTRIBUTE10
, POS.ATTRIBUTE11
, POS.ATTRIBUTE12
, POS.ATTRIBUTE13
, POS.ATTRIBUTE14
, POS.ATTRIBUTE15
, POS.ATTRIBUTE16
, POS.ATTRIBUTE17
, POS.ATTRIBUTE18
, POS.ATTRIBUTE19
, POS.ATTRIBUTE20
, POS.OBJECT_VERSION_NUMBER
, POS.PRIOR_EMPLOYMENT_SSP_PAID_TO
, POS.PRIOR_EMPLOYMENT_SSP_WEEKS
, POS.PDS_INFORMATION_CATEGORY
, POS.PDS_INFORMATION1
, POS.PDS_INFORMATION2
, POS.PDS_INFORMATION3
, POS.PDS_INFORMATION4
, POS.PDS_INFORMATION5
, POS.PDS_INFORMATION6
, POS.PDS_INFORMATION7
, POS.PDS_INFORMATION8
, POS.PDS_INFORMATION9
, POS.PDS_INFORMATION10
, POS.PDS_INFORMATION11
, POS.PDS_INFORMATION12
, POS.PDS_INFORMATION13
, POS.PDS_INFORMATION14
, POS.PDS_INFORMATION15
, POS.PDS_INFORMATION16
, POS.PDS_INFORMATION17
, POS.PDS_INFORMATION18
, POS.PDS_INFORMATION19
, POS.PDS_INFORMATION20
, POS.PDS_INFORMATION21
, POS.PDS_INFORMATION22
, POS.PDS_INFORMATION23
, POS.PDS_INFORMATION24
, POS.PDS_INFORMATION25
, POS.PDS_INFORMATION26
, POS.PDS_INFORMATION27
, POS.PDS_INFORMATION28
, POS.PDS_INFORMATION29
, POS.PDS_INFORMATION30
, ADDR.ADDRESS_ID
, ADDR.BUSINESS_GROUP_ID
, ADDR.PERSON_ID
, ADDR.DATE_FROM
, ADDR.PRIMARY_FLAG
, ADDR.STYLE
, ADDR.ADDRESS_LINE1
, ADDR.ADDRESS_LINE2
, ADDR.ADDRESS_LINE3
, ADDR.ADDRESS_TYPE
, ADDR.COMMENTS
, ADDR.COUNTRY
, ADDR.DATE_TO
, ADDR.POSTAL_CODE
, ADDR.REGION_1
, ADDR.REGION_2
, ADDR.REGION_3
, ADDR.TELEPHONE_NUMBER_1
, ADDR.TELEPHONE_NUMBER_2
, ADDR.TELEPHONE_NUMBER_3
, ADDR.TOWN_OR_CITY
, ADDR.REQUEST_ID
, ADDR.PROGRAM_APPLICATION_ID
, ADDR.PROGRAM_ID
, ADDR.PROGRAM_UPDATE_DATE
, ADDR.ADDR_ATTRIBUTE_CATEGORY
, ADDR.ADDR_ATTRIBUTE1
, ADDR.ADDR_ATTRIBUTE2
, ADDR.ADDR_ATTRIBUTE3
, ADDR.ADDR_ATTRIBUTE4
, ADDR.ADDR_ATTRIBUTE5
, ADDR.ADDR_ATTRIBUTE6
, ADDR.ADDR_ATTRIBUTE7
, ADDR.ADDR_ATTRIBUTE8
, ADDR.ADDR_ATTRIBUTE9
, ADDR.ADDR_ATTRIBUTE10
, ADDR.ADDR_ATTRIBUTE11
, ADDR.ADDR_ATTRIBUTE12
, ADDR.ADDR_ATTRIBUTE13
, ADDR.ADDR_ATTRIBUTE14
, ADDR.ADDR_ATTRIBUTE15
, ADDR.ADDR_ATTRIBUTE16
, ADDR.ADDR_ATTRIBUTE17
, ADDR.ADDR_ATTRIBUTE18
, ADDR.ADDR_ATTRIBUTE19
, ADDR.ADDR_ATTRIBUTE20
, ADDR.LAST_UPDATE_DATE
, ADDR.LAST_UPDATED_BY
, ADDR.LAST_UPDATE_LOGIN
, ADDR.CREATED_BY
, ADDR.CREATION_DATE
, ADDR.OBJECT_VERSION_NUMBER
, ADDR.ADD_INFORMATION13
, ADDR.ADD_INFORMATION14
, ADDR.ADD_INFORMATION15
, ADDR.ADD_INFORMATION16
, ADDR.ADD_INFORMATION17
, ADDR.ADD_INFORMATION18
, ADDR.ADD_INFORMATION19
, ADDR.ADD_INFORMATION20
, ADDR.PARTY_ID
, ADDR.DERIVED_LOCALE
FROM PER_ALL_PEOPLE_F PER
, PER_ALL_ASSIGNMENTS_F ASG
, PER_PERIODS_OF_SERVICE POS
, PER_PERSON_TYPES PPT
, PER_ADDRESSES ADDR
WHERE PER.PERSON_ID = ASG.PERSON_ID
AND ( PER.EFFECTIVE_START_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE OR ASG.EFFECTIVE_START_DATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE )
AND POS.PERSON_ID = PER.PERSON_ID
AND PER.PERSON_TYPE_ID = PPT.PERSON_TYPE_ID
AND PPT.SYSTEM_PERSON_TYPE = 'EMP'
AND PER.BUSINESS_GROUP_ID = PPT.BUSINESS_GROUP_ID
AND ASG.PRIMARY_FLAG = 'Y'
AND PER.EFFECTIVE_START_DATE BETWEEN POS.DATE_START
AND NVL(ACTUAL_TERMINATION_DATE
, PER.EFFECTIVE_START_DATE)
AND PER.PERSON_ID = ADDR.PERSON_ID(+)