VIEW: APPS.PERBV_CN_EXT_PER_INFO_V

Source

View Text - Preformatted

SELECT pei.person_extra_info_id , pei.person_id , paf.full_name , paf.employee_number , paf.business_group_id , pei.pei_information_category , pei.information_type , pei.pei_information1 , pei.pei_information2 , pei.pei_information3 , pei.pei_information4 , pei.pei_information5 , pei.pei_information6 , pei.pei_information7 , pei.pei_information8 , pei.pei_information9 , pei.pei_information10 , pei.pei_information11 , pei.pei_information12 , pei.pei_information13 , pei.pei_information14 , pei.pei_information15 , pei.pei_information16 , pei.pei_information17 , pei.pei_information18 , pei.pei_information19 , pei.pei_information20 , pei.pei_information21 , pei.pei_information22 , pei.pei_information23 , pei.pei_information24 , pei.pei_information25 , pei.pei_information26 , pei.pei_information27 , pei.pei_information28 , pei.pei_information29 , pei.pei_information30 FROM per_people_extra_info pei, per_people_f paf, per_business_groups pbf WHERE paf.person_id = pei.person_id AND SYSDATE BETWEEN paf.effective_start_date AND paf.effective_end_date AND pbf.business_group_id = paf.business_group_id WITH READ ONLY

View Text - HTML Formatted

SELECT PEI.PERSON_EXTRA_INFO_ID
, PEI.PERSON_ID
, PAF.FULL_NAME
, PAF.EMPLOYEE_NUMBER
, PAF.BUSINESS_GROUP_ID
, PEI.PEI_INFORMATION_CATEGORY
, PEI.INFORMATION_TYPE
, PEI.PEI_INFORMATION1
, PEI.PEI_INFORMATION2
, PEI.PEI_INFORMATION3
, PEI.PEI_INFORMATION4
, PEI.PEI_INFORMATION5
, PEI.PEI_INFORMATION6
, PEI.PEI_INFORMATION7
, PEI.PEI_INFORMATION8
, PEI.PEI_INFORMATION9
, PEI.PEI_INFORMATION10
, PEI.PEI_INFORMATION11
, PEI.PEI_INFORMATION12
, PEI.PEI_INFORMATION13
, PEI.PEI_INFORMATION14
, PEI.PEI_INFORMATION15
, PEI.PEI_INFORMATION16
, PEI.PEI_INFORMATION17
, PEI.PEI_INFORMATION18
, PEI.PEI_INFORMATION19
, PEI.PEI_INFORMATION20
, PEI.PEI_INFORMATION21
, PEI.PEI_INFORMATION22
, PEI.PEI_INFORMATION23
, PEI.PEI_INFORMATION24
, PEI.PEI_INFORMATION25
, PEI.PEI_INFORMATION26
, PEI.PEI_INFORMATION27
, PEI.PEI_INFORMATION28
, PEI.PEI_INFORMATION29
, PEI.PEI_INFORMATION30
FROM PER_PEOPLE_EXTRA_INFO PEI
, PER_PEOPLE_F PAF
, PER_BUSINESS_GROUPS PBF
WHERE PAF.PERSON_ID = PEI.PERSON_ID
AND SYSDATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PBF.BUSINESS_GROUP_ID = PAF.BUSINESS_GROUP_ID WITH READ ONLY