ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN FE87E1910FCE4DFCAAAE720B414739C0Y select null action_, null status_, null message_, null modified_columns_, to_number(null) person_extra_info_id_out, ppei.person_extra_info_id, papf.employee_number, papf.full_name, pbg.name business_group, fdfcv.descriptive_flex_context_name information_type, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION1',ppei.rowid,ppei.pei_information1) pei_information1, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION2',ppei.rowid,ppei.pei_information2) pei_information2, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION3',ppei.rowid,ppei.pei_information3) pei_information3, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION4',ppei.rowid,ppei.pei_information4) pei_information4, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION5',ppei.rowid,ppei.pei_information5) pei_information5, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION6',ppei.rowid,ppei.pei_information6) pei_information6, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION7',ppei.rowid,ppei.pei_information7) pei_information7, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION8',ppei.rowid,ppei.pei_information8) pei_information8, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION9',ppei.rowid,ppei.pei_information9) pei_information9, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION10',ppei.rowid,ppei.pei_information10) pei_information10, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION11',ppei.rowid,ppei.pei_information11) pei_information11, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION12',ppei.rowid,ppei.pei_information12) pei_information12, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION13',ppei.rowid,ppei.pei_information13) pei_information13, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION14',ppei.rowid,ppei.pei_information14) pei_information14, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION15',ppei.rowid,ppei.pei_information15) pei_information15, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION16',ppei.rowid,ppei.pei_information16) pei_information16, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION17',ppei.rowid,ppei.pei_information17) pei_information17, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION18',ppei.rowid,ppei.pei_information18) pei_information18, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION19',ppei.rowid,ppei.pei_information19) pei_information19, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION20',ppei.rowid,ppei.pei_information20) pei_information20, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION21',ppei.rowid,ppei.pei_information21) pei_information21, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION22',ppei.rowid,ppei.pei_information22) pei_information22, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION23',ppei.rowid,ppei.pei_information23) pei_information23, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION24',ppei.rowid,ppei.pei_information24) pei_information24, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION25',ppei.rowid,ppei.pei_information25) pei_information25, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION26',ppei.rowid,ppei.pei_information26) pei_information26, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION27',ppei.rowid,ppei.pei_information27) pei_information27, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION28',ppei.rowid,ppei.pei_information28) pei_information28, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION29',ppei.rowid,ppei.pei_information29) pei_information29, xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION30',ppei.rowid,ppei.pei_information30) pei_information30, 0 upload_row from per_business_groups pbg, per_all_people_f papf, per_people_extra_info ppei, fnd_descr_flex_contexts_vl fdfcv where 1=1 and pbg.business_group_id=:p_business_group and papf.business_group_id=pbg.business_group_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and ppei.person_id=papf.person_id and fdfcv.application_id=800 and fdfcv.descriptive_flexfield_name='Extra Person Info DDF' and fdfcv.descriptive_flex_context_code=ppei.pei_information_category and fdfcv.enabled_flag='Y' Initial version - generic upload to create and update person extra information types (EITs) via hr_person_extra_info_api U A xxen_per_upload.create_update_person_eit US PER Person Extra Information Upload Upload to create and update Person Extra Information Types (EITs) within Oracle HRMS - the People form > Others > Extra Information > Extra Person Information window. Scope: - Generic upload covering all person extra information types. The Information Type parameter/column lists every enabled context of the Extra Person Info DDF flexfield (titled Extra Person Information), which holds the registered EIT types. - The segment values are loaded as raw Information 1..30 columns (pei_information1..30), matching the order of the information type's flexfield segments. - Create new person extra information records and update existing ones (auto-detected by the hidden Person Extra Information ID downloaded in Create, Update mode). Notes: - A person can hold multiple records of the same information type (e.g. one per year), so existing rows are matched by the hidden Person Extra Information ID, not by person and type. - The information type must be eligible for the person; ineligible types are rejected by the API. - For information type segments validated against a value set, enter the stored value the segment expects. Enginatics Upload 1=1 :p_business_group 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 20 :p_business_group LOV custom Y select pbg.business_group_id id, pbg.name value, null description from per_business_groups pbg order by pbg.name fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group 3 30 1=1 papf.employee_number=:employee_number LOV custom Y Y select papf.employee_number id, papf.employee_number value, papf.full_name description from per_all_people_f papf where papf.business_group_id=:$flex$.Business_Group and papf.employee_number is not null and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date order by papf.employee_number US Employee Number 4 40 1=1 ppei.pei_information_category=:information_type LOV custom Y select fdfcv.descriptive_flex_context_code id, fdfcv.descriptive_flex_context_name value, null description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=800 and fdfcv.descriptive_flexfield_name='Extra Person Info DDF' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name US Information Type 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 PERSON_EXTRA_INFO_ID_OUT Number number Y 6 PERSON_EXTRA_INFO_ID Number number Y 7 EMPLOYEE_NUMBER LOV custom varchar2 30 Y Y select papf.employee_number id, papf.employee_number value, papf.full_name description from per_all_people_f papf where papf.business_group_id=(select pbg.business_group_id from per_business_groups pbg where pbg.name=:$column$.business_group) and papf.employee_number is not null and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date order by papf.employee_number Y 8 FULL_NAME Char varchar2 240 select papf.full_name from per_all_people_f papf where papf.employee_number=:$column$.employee_number and papf.business_group_id=(select pbg.business_group_id from per_business_groups pbg where pbg.name=:$column$.business_group) and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date Y 9 BUSINESS_GROUP LOV custom varchar2 240 Y select pbg.business_group_id id, pbg.name value, null description from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group order by pbg.name select pbg.name from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group Y Y 10 INFORMATION_TYPE LOV custom varchar2 80 Y select fdfcv.descriptive_flex_context_code id, fdfcv.descriptive_flex_context_name value, null description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=800 and fdfcv.descriptive_flexfield_name='Extra Person Info DDF' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name Y 11 PEI_INFORMATION1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION1', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 12 PEI_INFORMATION2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION2', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 13 PEI_INFORMATION3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION3', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 14 PEI_INFORMATION4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION4', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 15 PEI_INFORMATION5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION5', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 16 PEI_INFORMATION6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION6', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 17 PEI_INFORMATION7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION7', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 18 PEI_INFORMATION8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION8', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 19 PEI_INFORMATION9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION9', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 20 PEI_INFORMATION10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION10', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 21 PEI_INFORMATION11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION11', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 22 PEI_INFORMATION12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION12', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 23 PEI_INFORMATION13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION13', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 24 PEI_INFORMATION14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION14', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 25 PEI_INFORMATION15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION15', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 26 PEI_INFORMATION16 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION16', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 27 PEI_INFORMATION17 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION17', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 28 PEI_INFORMATION18 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION18', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 29 PEI_INFORMATION19 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION19', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 30 PEI_INFORMATION20 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION20', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 31 PEI_INFORMATION21 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION21', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 32 PEI_INFORMATION22 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION22', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 33 PEI_INFORMATION23 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION23', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 34 PEI_INFORMATION24 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION24', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 35 PEI_INFORMATION25 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION25', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 36 PEI_INFORMATION26 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION26', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 37 PEI_INFORMATION27 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION27', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 38 PEI_INFORMATION28 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION28', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 39 PEI_INFORMATION29 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION29', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 40 PEI_INFORMATION30 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Extra Person Info DDF', p_context_name=>:$column$.information_type, p_column_name=>'PEI_INFORMATION30', p_attribute1=>:$column$.pei_information1, p_attribute2=>:$column$.pei_information2, p_attribute3=>:$column$.pei_information3, p_attribute4=>:$column$.pei_information4, p_attribute5=>:$column$.pei_information5, p_attribute6=>:$column$.pei_information6, p_attribute7=>:$column$.pei_information7, p_attribute8=>:$column$.pei_information8, p_attribute9=>:$column$.pei_information9, p_attribute10=>:$column$.pei_information10, p_attribute11=>:$column$.pei_information11, p_attribute12=>:$column$.pei_information12, p_attribute13=>:$column$.pei_information13, p_attribute14=>:$column$.pei_information14, p_attribute15=>:$column$.pei_information15, p_attribute16=>:$column$.pei_information16, p_attribute17=>:$column$.pei_information17, p_attribute18=>:$column$.pei_information18, p_attribute19=>:$column$.pei_information19, p_attribute20=>:$column$.pei_information20, p_attribute21=>:$column$.pei_information21, p_attribute22=>:$column$.pei_information22, p_attribute23=>:$column$.pei_information23, p_attribute24=>:$column$.pei_information24, p_attribute25=>:$column$.pei_information25, p_attribute26=>:$column$.pei_information26, p_attribute27=>:$column$.pei_information27, p_attribute28=>:$column$.pei_information28, p_attribute29=>:$column$.pei_information29, p_attribute30=>:$column$.pei_information30)) lov order by value 41 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 p_person_extra_info_id_out in/out Number PERSON_EXTRA_INFO_ID_OUT U 3 p_business_group_id in Number BUSINESS_GROUP U 4 p_employee_number in Char EMPLOYEE_NUMBER U 5 p_information_type in Char INFORMATION_TYPE U 6 p_person_extra_info_id in Number PERSON_EXTRA_INFO_ID U 7 p_pei_information1 in Char PEI_INFORMATION1 U 8 p_pei_information2 in Char PEI_INFORMATION2 U 9 p_pei_information3 in Char PEI_INFORMATION3 U 10 p_pei_information4 in Char PEI_INFORMATION4 U 11 p_pei_information5 in Char PEI_INFORMATION5 U 12 p_pei_information6 in Char PEI_INFORMATION6 U 13 p_pei_information7 in Char PEI_INFORMATION7 U 14 p_pei_information8 in Char PEI_INFORMATION8 U 15 p_pei_information9 in Char PEI_INFORMATION9 U 16 p_pei_information10 in Char PEI_INFORMATION10 U 17 p_pei_information11 in Char PEI_INFORMATION11 U 18 p_pei_information12 in Char PEI_INFORMATION12 U 19 p_pei_information13 in Char PEI_INFORMATION13 U 20 p_pei_information14 in Char PEI_INFORMATION14 U 21 p_pei_information15 in Char PEI_INFORMATION15 U 22 p_pei_information16 in Char PEI_INFORMATION16 U 23 p_pei_information17 in Char PEI_INFORMATION17 U 24 p_pei_information18 in Char PEI_INFORMATION18 U 25 p_pei_information19 in Char PEI_INFORMATION19 U 26 p_pei_information20 in Char PEI_INFORMATION20 U 27 p_pei_information21 in Char PEI_INFORMATION21 U 28 p_pei_information22 in Char PEI_INFORMATION22 U 29 p_pei_information23 in Char PEI_INFORMATION23 U 30 p_pei_information24 in Char PEI_INFORMATION24 U 31 p_pei_information25 in Char PEI_INFORMATION25 U 32 p_pei_information26 in Char PEI_INFORMATION26 U 33 p_pei_information27 in Char PEI_INFORMATION27 U 34 p_pei_information28 in Char PEI_INFORMATION28 U 35 p_pei_information29 in Char PEI_INFORMATION29 U 36 p_pei_information30 in Char PEI_INFORMATION30 U 37 status_ out Char STATUS_CODE_ U 38 message_ out Char MESSAGE_ Error SQL Order By upload_row, employee_number, information_type Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.person_extra_info_id_out, nvl(ppei.person_extra_info_id,xu.person_extra_info_id) person_extra_info_id, nvl(papf.employee_number,xu.employee_number) employee_number, nvl(papf.full_name,xu.full_name) full_name, nvl(pbg.name,xu.business_group) business_group, nvl(fdfcv.descriptive_flex_context_name,xu.information_type) information_type, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION1',ppei.rowid,ppei.pei_information1),xu.pei_information1) pei_information1, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION2',ppei.rowid,ppei.pei_information2),xu.pei_information2) pei_information2, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION3',ppei.rowid,ppei.pei_information3),xu.pei_information3) pei_information3, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION4',ppei.rowid,ppei.pei_information4),xu.pei_information4) pei_information4, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION5',ppei.rowid,ppei.pei_information5),xu.pei_information5) pei_information5, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION6',ppei.rowid,ppei.pei_information6),xu.pei_information6) pei_information6, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION7',ppei.rowid,ppei.pei_information7),xu.pei_information7) pei_information7, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION8',ppei.rowid,ppei.pei_information8),xu.pei_information8) pei_information8, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION9',ppei.rowid,ppei.pei_information9),xu.pei_information9) pei_information9, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION10',ppei.rowid,ppei.pei_information10),xu.pei_information10) pei_information10, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION11',ppei.rowid,ppei.pei_information11),xu.pei_information11) pei_information11, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION12',ppei.rowid,ppei.pei_information12),xu.pei_information12) pei_information12, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION13',ppei.rowid,ppei.pei_information13),xu.pei_information13) pei_information13, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION14',ppei.rowid,ppei.pei_information14),xu.pei_information14) pei_information14, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION15',ppei.rowid,ppei.pei_information15),xu.pei_information15) pei_information15, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION16',ppei.rowid,ppei.pei_information16),xu.pei_information16) pei_information16, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION17',ppei.rowid,ppei.pei_information17),xu.pei_information17) pei_information17, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION18',ppei.rowid,ppei.pei_information18),xu.pei_information18) pei_information18, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION19',ppei.rowid,ppei.pei_information19),xu.pei_information19) pei_information19, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION20',ppei.rowid,ppei.pei_information20),xu.pei_information20) pei_information20, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION21',ppei.rowid,ppei.pei_information21),xu.pei_information21) pei_information21, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION22',ppei.rowid,ppei.pei_information22),xu.pei_information22) pei_information22, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION23',ppei.rowid,ppei.pei_information23),xu.pei_information23) pei_information23, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION24',ppei.rowid,ppei.pei_information24),xu.pei_information24) pei_information24, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION25',ppei.rowid,ppei.pei_information25),xu.pei_information25) pei_information25, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION26',ppei.rowid,ppei.pei_information26),xu.pei_information26) pei_information26, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION27',ppei.rowid,ppei.pei_information27),xu.pei_information27) pei_information27, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION28',ppei.rowid,ppei.pei_information28),xu.pei_information28) pei_information28, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION29',ppei.rowid,ppei.pei_information29),xu.pei_information29) pei_information29, nvl(xxen_util.display_flexfield_value(800,'Extra Person Info DDF',ppei.pei_information_category,'PEI_INFORMATION30',ppei.rowid,ppei.pei_information30),xu.pei_information30) pei_information30, xu.upload_row from xxen_per_person_extra_i_8134_u xu, per_people_extra_info ppei, per_all_people_f papf, per_business_groups pbg, fnd_descr_flex_contexts_vl fdfcv where xu.status_code_=xxen_upload.status_success and xu.person_extra_info_id_out=ppei.person_extra_info_id(+) and ppei.person_id=papf.person_id(+) and trunc(sysdate) between papf.effective_start_date(+) and papf.effective_end_date(+) and papf.business_group_id=pbg.business_group_id(+) and fdfcv.application_id(+)=800 and fdfcv.descriptive_flexfield_name(+)='Extra Person Info DDF' and fdfcv.descriptive_flex_context_code(+)=ppei.pei_information_category and fdfcv.enabled_flag(+)='Y'