ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E1CF4CD449E14DB5BAF661A45C527F89Y select null action_, null status_, null message_, null modified_columns_, to_number(null) person_id_out, papf.person_id, pbg.name business_group, decode(pptuf.system_person_type,'CWK',papf.npw_number,'EX_CWK',papf.npw_number,'APL',papf.applicant_number,'EX_APL',papf.applicant_number,papf.employee_number) person_number, papf.full_name, papf.last_name, papf.first_name, xxen_util.meaning(papf.title,'TITLE',3) title, papf.pre_name_adjunct prefix, papf.suffix, papf.middle_names, xxen_util.meaning(papf.sex,'SEX',3) gender, pptt.user_person_type person_type, papf.national_identifier, :effective_date effective_date, null datetrack_mode, coalesce(ppos.date_start,ppop.date_start,papf.start_date) latest_start_date, papf.date_of_birth birth_date, papf.town_of_birth, papf.region_of_birth, (select ftv.territory_short_name from fnd_territories_vl ftv where papf.country_of_birth=ftv.territory_code) country_of_birth, xxen_util.meaning(papf.marital_status,'MAR_STATUS',3) marital_status, xxen_util.meaning(papf.nationality,'NATIONALITY',3) nationality, xxen_util.meaning(papf.registered_disabled_flag,'REGISTERED_DISABLED',3) registered_disabled, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION1',papf.rowid,papf.per_information1) per_information1, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION2',papf.rowid,papf.per_information2) per_information2, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION3',papf.rowid,papf.per_information3) per_information3, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION4',papf.rowid,papf.per_information4) per_information4, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION5',papf.rowid,papf.per_information5) per_information5, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION6',papf.rowid,papf.per_information6) per_information6, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION7',papf.rowid,papf.per_information7) per_information7, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION8',papf.rowid,papf.per_information8) per_information8, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION9',papf.rowid,papf.per_information9) per_information9, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION10',papf.rowid,papf.per_information10) per_information10, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION11',papf.rowid,papf.per_information11) per_information11, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION12',papf.rowid,papf.per_information12) per_information12, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION13',papf.rowid,papf.per_information13) per_information13, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION14',papf.rowid,papf.per_information14) per_information14, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION15',papf.rowid,papf.per_information15) per_information15, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION16',papf.rowid,papf.per_information16) per_information16, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION17',papf.rowid,papf.per_information17) per_information17, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION18',papf.rowid,papf.per_information18) per_information18, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION19',papf.rowid,papf.per_information19) per_information19, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION20',papf.rowid,papf.per_information20) per_information20, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION21',papf.rowid,papf.per_information21) per_information21, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION22',papf.rowid,papf.per_information22) per_information22, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION23',papf.rowid,papf.per_information23) per_information23, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION24',papf.rowid,papf.per_information24) per_information24, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION25',papf.rowid,papf.per_information25) per_information25, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION26',papf.rowid,papf.per_information26) per_information26, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION27',papf.rowid,papf.per_information27) per_information27, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION28',papf.rowid,papf.per_information28) per_information28, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION29',papf.rowid,papf.per_information29) per_information29, xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION30',papf.rowid,papf.per_information30) per_information30, papf.office_number office, papf.internal_location location, papf.mailstop, papf.email_address email, xxen_util.meaning(papf.expense_check_send_to_address,'HOME_OFFICE',3) mail_to, papf.honors, papf.known_as preferred_name, papf.previous_last_name, (select flv.description from fnd_languages_vl flv where papf.correspondence_language=flv.language_code) correspondence_language, papf.date_employee_data_verified date_last_verified, xxen_util.meaning(papf.student_status,'STUDENT_STATUS',3) student_status, xxen_util.yes(papf.on_military_service) on_military_service, xxen_util.yes(papf.second_passport_exists) second_passport, papf.original_date_of_hire date_first_hired, nvl(ppos.actual_termination_date,ppop.actual_termination_date) termination_date, nvl(xxen_util.meaning(ppos.leaving_reason,'LEAV_REAS',3),xxen_util.meaning(ppop.termination_reason,'HR_CWK_TERMINATION_REASONS',3)) leaving_reason, nvl(ppos.final_process_date,ppop.final_process_date) final_process_date, xxen_util.display_flexfield_context(800,'PER_PEOPLE',papf.attribute_category) per_attribute_category, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE1',papf.rowid,papf.attribute1) per_attribute1, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE2',papf.rowid,papf.attribute2) per_attribute2, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE3',papf.rowid,papf.attribute3) per_attribute3, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE4',papf.rowid,papf.attribute4) per_attribute4, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE5',papf.rowid,papf.attribute5) per_attribute5, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE6',papf.rowid,papf.attribute6) per_attribute6, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE7',papf.rowid,papf.attribute7) per_attribute7, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE8',papf.rowid,papf.attribute8) per_attribute8, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE9',papf.rowid,papf.attribute9) per_attribute9, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE10',papf.rowid,papf.attribute10) per_attribute10, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE11',papf.rowid,papf.attribute11) per_attribute11, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE12',papf.rowid,papf.attribute12) per_attribute12, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE13',papf.rowid,papf.attribute13) per_attribute13, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE14',papf.rowid,papf.attribute14) per_attribute14, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE15',papf.rowid,papf.attribute15) per_attribute15, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE16',papf.rowid,papf.attribute16) per_attribute16, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE17',papf.rowid,papf.attribute17) per_attribute17, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE18',papf.rowid,papf.attribute18) per_attribute18, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE19',papf.rowid,papf.attribute19) per_attribute19, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE20',papf.rowid,papf.attribute20) per_attribute20, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE21',papf.rowid,papf.attribute21) per_attribute21, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE22',papf.rowid,papf.attribute22) per_attribute22, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE23',papf.rowid,papf.attribute23) per_attribute23, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE24',papf.rowid,papf.attribute24) per_attribute24, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE25',papf.rowid,papf.attribute25) per_attribute25, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE26',papf.rowid,papf.attribute26) per_attribute26, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE27',papf.rowid,papf.attribute27) per_attribute27, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE28',papf.rowid,papf.attribute28) per_attribute28, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE29',papf.rowid,papf.attribute29) per_attribute29, xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE30',papf.rowid,papf.attribute30) per_attribute30, 0 upload_row from per_business_groups pbg, per_all_people_f papf, ( select pptuf.person_id, max(ppt.person_type_id) keep (dense_rank first order by decode(ppt.system_person_type,'EMP',1,'CWK',2,'APL',3,'EX_EMP',4,'EX_CWK',5,6)) person_type_id, max(ppt.system_person_type) keep (dense_rank first order by decode(ppt.system_person_type,'EMP',1,'CWK',2,'APL',3,'EX_EMP',4,'EX_CWK',5,6)) system_person_type from per_person_type_usages_f pptuf, per_person_types ppt where :effective_date between pptuf.effective_start_date and pptuf.effective_end_date and pptuf.person_type_id=ppt.person_type_id and ppt.business_group_id=:business_group_id and ppt.system_person_type in ('EMP','CWK','APL','EX_EMP','EX_CWK','EX_APL') group by pptuf.person_id ) pptuf, per_person_types_tl pptt, ( select ppos.person_id, ppos.date_start, ppos.actual_termination_date, ppos.final_process_date, ppos.leaving_reason, row_number() over (partition by ppos.person_id order by ppos.date_start desc) rn from per_periods_of_service ppos where ppos.business_group_id=:business_group_id and ppos.date_start<=:effective_date ) ppos, ( select ppop.person_id, ppop.date_start, ppop.actual_termination_date, ppop.final_process_date, ppop.termination_reason, row_number() over (partition by ppop.person_id order by ppop.date_start desc) rn from per_periods_of_placement ppop where ppop.business_group_id=:business_group_id and ppop.date_start<=:effective_date ) ppop where 1=1 and pbg.business_group_id=:business_group_id and papf.business_group_id=pbg.business_group_id and :effective_date between papf.effective_start_date and papf.effective_end_date and papf.person_id=pptuf.person_id and pptuf.person_type_id=pptt.person_type_id and pptt.language=userenv('lang') and papf.person_id=ppos.person_id(+) and ppos.rn(+)=1 and papf.person_id=ppop.person_id(+) and ppop.rn(+)=1 Initial version - create employees, contingent workers and applicants, update person details, rehire ex-employees and terminate employees and placements through the HR person APIs U A xxen_per_upload.create_update_person US PER Person Upload Upload to create and update people as in the People form (Combined Person and Assignment form, People window): employees, contingent workers and applicants, their personal details, Further Person Information and Additional Personal Details flexfields. A new person is created with hr_employee_api, hr_contingent_worker_api or hr_applicant_api depending on the system type of the Person Type. The Latest Start Date is the hire, placement or application date, and the API creates the default primary assignment in the business group. Use the PER Person Assignment Upload for the assignment details. Person details are changed as of the Effective Date. When Datetrack Mode is blank, the record is corrected if the Effective Date is its start date, and otherwise a change is inserted from the Effective Date (Update, or Update - Insert when later changes exist). Entering a Termination Date terminates an employee (with the Final Process Date if given) or ends a contingent worker placement. Changing the Person Type of an ex-employee to an employee person type rehires the employee on the Latest Start Date. Existing people are matched by the hidden person id when downloaded, otherwise by Person Number: the employee number, contingent worker number or applicant number according to the Person Type. Enginatics Upload 1=1 :business_group_id :effective_date 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 :business_group_id 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 :effective_date Date trunc(sysdate) Y US Effective Date Date the downloaded records are shown as of and the default date the uploaded changes take effect. 4 40 1=1 pptuf.person_type_id=:person_type_id LOV custom Y select ppt.person_type_id id, pptt.user_person_type value, xxen_util.meaning(ppt.system_person_type,'PERSON_TYPE',3) description from per_person_types ppt, per_person_types_tl pptt where ppt.business_group_id=:$flex$.Business_Group and ppt.system_person_type in ('EMP','CWK','APL','EX_EMP','EX_CWK','EX_APL') and ppt.person_type_id=pptt.person_type_id and pptt.language=userenv('lang') order by pptt.user_person_type US Person Type 5 50 1=1 decode(pptuf.system_person_type,'CWK',papf.npw_number,'EX_CWK',papf.npw_number,'APL',papf.applicant_number,'EX_APL',papf.applicant_number,papf.employee_number)=:person_number Char US Person Number 6 60 1=1 upper(papf.full_name) like upper(:full_name) Char US Full Name like 7 70 1=1 papf.person_id in (select paaf.person_id from per_all_assignments_f paaf where paaf.organization_id=:organization_id and paaf.primary_flag='Y' and :effective_date between paaf.effective_start_date and paaf.effective_end_date) LOV custom Y select haouv.organization_id id, haouv.name value, null description from hr_all_organization_units_vl haouv where haouv.business_group_id=:$flex$.Business_Group order by haouv.name US Organization Restricts the download to people whose primary assignment is in this organization. 76976FA588D24B4193D6E38A6F9F6DB2 Default Creates and updates people with the fields of the People form, without the flexfields. ENGINATICS 16 BIRTH_DATE 1 BUSINESS_GROUP 31 CORRESPONDENCE_LANGUAGE 19 COUNTRY_OF_BIRTH 14 DATETRACK_MODE 36 DATE_FIRST_HIRED 32 DATE_LAST_VERIFIED 13 EFFECTIVE_DATE 26 EMAIL 39 FINAL_PROCESS_DATE 5 FIRST_NAME 3 FULL_NAME 10 GENDER 28 HONORS 4 LAST_NAME Y 15 LATEST_START_DATE 38 LEAVING_REASON 24 LOCATION 25 MAILSTOP 27 MAIL_TO 20 MARITAL_STATUS 9 MIDDLE_NAMES 21 NATIONALITY 12 NATIONAL_IDENTIFIER 23 OFFICE 34 ON_MILITARY_SERVICE 2 PERSON_NUMBER 11 PERSON_TYPE 29 PREFERRED_NAME 7 PREFIX 30 PREVIOUS_LAST_NAME 18 REGION_OF_BIRTH 22 REGISTERED_DISABLED 35 SECOND_PASSPORT 33 STUDENT_STATUS 8 SUFFIX 37 TERMINATION_DATE 6 TITLE 17 TOWN_OF_BIRTH Upload Mode C,U S Site 392F9424333C44D3894F54DA3B27B9D5 Flexfields Maintains the Further Person Information and the Additional Personal Details flexfields of existing people. ENGINATICS 1 BUSINESS_GROUP 5 DATETRACK_MODE 4 EFFECTIVE_DATE Y 3 FULL_NAME 2 PERSON_NUMBER 37 PER_ATTRIBUTE1 46 PER_ATTRIBUTE10 47 PER_ATTRIBUTE11 48 PER_ATTRIBUTE12 49 PER_ATTRIBUTE13 50 PER_ATTRIBUTE14 51 PER_ATTRIBUTE15 52 PER_ATTRIBUTE16 53 PER_ATTRIBUTE17 54 PER_ATTRIBUTE18 55 PER_ATTRIBUTE19 38 PER_ATTRIBUTE2 56 PER_ATTRIBUTE20 57 PER_ATTRIBUTE21 58 PER_ATTRIBUTE22 59 PER_ATTRIBUTE23 60 PER_ATTRIBUTE24 61 PER_ATTRIBUTE25 62 PER_ATTRIBUTE26 63 PER_ATTRIBUTE27 64 PER_ATTRIBUTE28 65 PER_ATTRIBUTE29 39 PER_ATTRIBUTE3 66 PER_ATTRIBUTE30 40 PER_ATTRIBUTE4 41 PER_ATTRIBUTE5 42 PER_ATTRIBUTE6 43 PER_ATTRIBUTE7 44 PER_ATTRIBUTE8 45 PER_ATTRIBUTE9 36 PER_ATTRIBUTE_CATEGORY 6 PER_INFORMATION1 15 PER_INFORMATION10 16 PER_INFORMATION11 17 PER_INFORMATION12 18 PER_INFORMATION13 19 PER_INFORMATION14 20 PER_INFORMATION15 21 PER_INFORMATION16 22 PER_INFORMATION17 23 PER_INFORMATION18 24 PER_INFORMATION19 7 PER_INFORMATION2 25 PER_INFORMATION20 26 PER_INFORMATION21 27 PER_INFORMATION22 28 PER_INFORMATION23 29 PER_INFORMATION24 30 PER_INFORMATION25 31 PER_INFORMATION26 32 PER_INFORMATION27 33 PER_INFORMATION28 34 PER_INFORMATION29 8 PER_INFORMATION3 35 PER_INFORMATION30 9 PER_INFORMATION4 10 PER_INFORMATION5 11 PER_INFORMATION6 12 PER_INFORMATION7 13 PER_INFORMATION8 14 PER_INFORMATION9 Upload Mode C,U S Site 252811C118E34E32A7ECB283F1CCEB81 New Hire Opens an empty sheet to enter new employees, contingent workers or applicants. The Latest Start Date is the hire date, and the primary assignment is created in the business group. Enter the assignment details with the PER Person Assignment Upload. ENGINATICS 12 BIRTH_DATE 1 BUSINESS_GROUP 14 COUNTRY_OF_BIRTH 17 EMAIL 5 FIRST_NAME 3 FULL_NAME 8 GENDER 4 LAST_NAME Y 11 LATEST_START_DATE 15 MARITAL_STATUS 7 MIDDLE_NAMES 16 NATIONALITY 10 NATIONAL_IDENTIFIER 2 PERSON_NUMBER 9 PERSON_TYPE 18 PER_INFORMATION1 27 PER_INFORMATION10 28 PER_INFORMATION11 29 PER_INFORMATION12 30 PER_INFORMATION13 31 PER_INFORMATION14 32 PER_INFORMATION15 33 PER_INFORMATION16 34 PER_INFORMATION17 35 PER_INFORMATION18 36 PER_INFORMATION19 19 PER_INFORMATION2 37 PER_INFORMATION20 38 PER_INFORMATION21 39 PER_INFORMATION22 40 PER_INFORMATION23 41 PER_INFORMATION24 42 PER_INFORMATION25 43 PER_INFORMATION26 44 PER_INFORMATION27 45 PER_INFORMATION28 46 PER_INFORMATION29 20 PER_INFORMATION3 47 PER_INFORMATION30 21 PER_INFORMATION4 22 PER_INFORMATION5 23 PER_INFORMATION6 24 PER_INFORMATION7 25 PER_INFORMATION8 26 PER_INFORMATION9 6 TITLE 13 TOWN_OF_BIRTH Upload Mode C Y S Site Full Name like Organization Person Number Person Type C6AE6F5A39FC44ACB0D5D335E9ED3A21 Termination Terminates employees and ends contingent worker placements. Enter the Termination Date and Leaving Reason, and the Final Process Date to close the period of service as well. ENGINATICS 1 BUSINESS_GROUP 8 FINAL_PROCESS_DATE 3 FULL_NAME 5 LATEST_START_DATE 7 LEAVING_REASON 2 PERSON_NUMBER 4 PERSON_TYPE Y 6 TERMINATION_DATE Upload Mode C,U S Site 76976FA588D24B4193D6E38A6F9F6DB2 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 PERSON_ID_OUT Number number Y 6 PERSON_ID Number number Y 7 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 8 PERSON_NUMBER Char varchar2 30 Employee number for employees and ex-employees, contingent worker number for contingent workers, applicant number for applicants. Leave blank for a new person when the business group generates numbers automatically. 9 FULL_NAME Char varchar2 240 select distinct papf.full_name from per_all_people_f papf, per_business_groups pbg where pbg.name=:$column$.business_group and papf.business_group_id=pbg.business_group_id and :$column$.person_number in (papf.employee_number,papf.npw_number,papf.applicant_number) and nvl(:$column$.effective_date,trunc(sysdate)) between papf.effective_start_date and papf.effective_end_date Y 10 LAST_NAME Char varchar2 150 Y 11 FIRST_NAME Char varchar2 150 12 TITLE LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from per_business_groups pbg, fnd_lookup_values_vl flvv where pbg.name=:$column$.business_group and flvv.lookup_type='TITLE' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and (flvv.tag is null or flvv.tag like '%+'||pbg.legislation_code||'%' or flvv.tag like '-%' and flvv.tag not like '%'||pbg.legislation_code||'%') order by flvv.meaning 13 PREFIX Char varchar2 30 14 SUFFIX Char varchar2 30 15 MIDDLE_NAMES Char varchar2 60 16 GENDER LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='SEX' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning 17 PERSON_TYPE LOV custom varchar2 80 Y select ppt.person_type_id id, pptt.user_person_type value, xxen_util.meaning(ppt.system_person_type,'PERSON_TYPE',3) description from per_business_groups pbg, per_person_types ppt, per_person_types_tl pptt where pbg.name=:$column$.business_group and ppt.business_group_id=pbg.business_group_id and ppt.system_person_type in ('EMP','CWK','APL','EX_EMP','EX_CWK','EX_APL') and ppt.active_flag='Y' and ppt.person_type_id=pptt.person_type_id and pptt.language=userenv('lang') order by pptt.user_person_type A new person must have an employee, contingent worker or applicant person type. Changing an ex-employee to an employee person type rehires the employee on the Latest Start Date. Y 18 NATIONAL_IDENTIFIER Char varchar2 30 19 EFFECTIVE_DATE Date date :$flex$.Effective_Date Date the person details are changed on. Defaults from the Effective Date parameter. 20 DATETRACK_MODE LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='PQH_DT_MODE' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and flvv.lookup_code in ('CORRECTION','UPDATE','UPDATE_CHANGE_INSERT','UPDATE_OVERRIDE') order by flvv.meaning Leave blank to correct the record when the Effective Date is its start date and to insert a change otherwise. 21 LATEST_START_DATE Date date Hire date of a new employee, placement start of a new contingent worker, application date of a new applicant, or the rehire date of an ex-employee. 22 BIRTH_DATE Date date 23 TOWN_OF_BIRTH Char varchar2 90 24 REGION_OF_BIRTH Char varchar2 90 25 COUNTRY_OF_BIRTH LOV custom varchar2 80 Y select ftv.territory_code id, ftv.territory_short_name value, null description from fnd_territories_vl ftv order by ftv.territory_short_name 26 MARITAL_STATUS LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from per_business_groups pbg, fnd_lookup_values_vl flvv where pbg.name=:$column$.business_group and flvv.lookup_type='MAR_STATUS' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and (flvv.tag is null or flvv.tag like '%+'||pbg.legislation_code||'%' or flvv.tag like '-%' and flvv.tag not like '%'||pbg.legislation_code||'%') order by flvv.meaning 27 NATIONALITY LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from per_business_groups pbg, fnd_lookup_values_vl flvv where pbg.name=:$column$.business_group and flvv.lookup_type='NATIONALITY' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and (flvv.tag is null or flvv.tag like '%+'||pbg.legislation_code||'%' or flvv.tag like '-%' and flvv.tag not like '%'||pbg.legislation_code||'%') order by flvv.meaning 28 REGISTERED_DISABLED LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from per_business_groups pbg, fnd_lookup_values_vl flvv where pbg.name=:$column$.business_group and flvv.lookup_type='REGISTERED_DISABLED' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and (flvv.tag is null or flvv.tag like '%+'||pbg.legislation_code||'%' or flvv.tag like '-%' and flvv.tag not like '%'||pbg.legislation_code||'%') order by flvv.meaning 29 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION1', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION1' 30 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION2', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION2' 31 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION3', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION3' 32 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION4', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION4' 33 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION5', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION5' 34 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION6', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION6' 35 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION7', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION7' 36 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION8', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION8' 37 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION9', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION9' 38 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION10', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION10' 39 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION11', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION11' 40 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION12', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION12' 41 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION13', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION13' 42 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION14', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION14' 43 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION15', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION15' 44 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION16', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION16' 45 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION17', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION17' 46 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION18', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION18' 47 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION19', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION19' 48 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION20', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION20' 49 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION21', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION21' 50 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION22', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION22' 51 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION23', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION23' 52 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION24', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION24' 53 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION25', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION25' 54 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION26', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION26' 55 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION27', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION27' 56 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION28', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION28' 57 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION29', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION29' 58 PER_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 (select pbg.legislation_code from per_business_groups pbg where pbg.name=:$column$.business_group) s, table(xxen_util.dff_attribute_lov( p_application_id=>800, p_descriptive_flexfield_name=>'Person Developer DF', p_context_name=>s.legislation_code, p_column_name=>'PER_INFORMATION30', p_attribute1=>:$column$.per_information1, p_attribute2=>:$column$.per_information2, p_attribute3=>:$column$.per_information3, p_attribute4=>:$column$.per_information4, p_attribute5=>:$column$.per_information5, p_attribute6=>:$column$.per_information6, p_attribute7=>:$column$.per_information7, p_attribute8=>:$column$.per_information8, p_attribute9=>:$column$.per_information9, p_attribute10=>:$column$.per_information10, p_attribute11=>:$column$.per_information11, p_attribute12=>:$column$.per_information12, p_attribute13=>:$column$.per_information13, p_attribute14=>:$column$.per_information14, p_attribute15=>:$column$.per_information15, p_attribute16=>:$column$.per_information16, p_attribute17=>:$column$.per_information17, p_attribute18=>:$column$.per_information18, p_attribute19=>:$column$.per_information19, p_attribute20=>:$column$.per_information20, p_attribute21=>:$column$.per_information21, p_attribute22=>:$column$.per_information22, p_attribute23=>:$column$.per_information23, p_attribute24=>:$column$.per_information24, p_attribute25=>:$column$.per_information25, p_attribute26=>:$column$.per_information26, p_attribute27=>:$column$.per_information27, p_attribute28=>:$column$.per_information28, p_attribute29=>:$column$.per_information29, p_attribute30=>:$column$.per_information30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='Person Developer DF' and fdfc.enabled_flag='Y' and fdfc.descriptive_flex_context_code=(select pbg.legislation_code from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group) and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='PER_INFORMATION30' 59 OFFICE Char varchar2 45 60 LOCATION Char varchar2 45 61 MAILSTOP Char varchar2 45 62 EMAIL Char varchar2 240 63 MAIL_TO LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='HOME_OFFICE' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning 64 HONORS Char varchar2 45 65 PREFERRED_NAME Char varchar2 80 66 PREVIOUS_LAST_NAME Char varchar2 150 67 CORRESPONDENCE_LANGUAGE LOV custom varchar2 80 Y select flv.language_code id, flv.description value, null description from fnd_languages_vl flv order by flv.description 68 DATE_LAST_VERIFIED Date date 69 STUDENT_STATUS LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='STUDENT_STATUS' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning 70 ON_MILITARY_SERVICE LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 71 SECOND_PASSPORT LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 72 DATE_FIRST_HIRED Date date 73 TERMINATION_DATE Date date Actual termination date of the employee or end date of the contingent worker placement. Entering it terminates the person. 74 LEAVING_REASON LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from per_business_groups pbg, per_person_types ppt, per_person_types_tl pptt, fnd_lookup_values_vl flvv where pbg.name=:$column$.business_group and ppt.business_group_id=pbg.business_group_id and ppt.person_type_id=pptt.person_type_id and pptt.language=userenv('lang') and pptt.user_person_type=:$column$.person_type and flvv.lookup_type=decode(ppt.system_person_type,'CWK','HR_CWK_TERMINATION_REASONS','EX_CWK','HR_CWK_TERMINATION_REASONS','LEAV_REAS') and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and (flvv.tag is null or flvv.tag like '%+'||pbg.legislation_code||'%' or flvv.tag like '-%' and flvv.tag not like '%'||pbg.legislation_code||'%') order by flvv.meaning 75 FINAL_PROCESS_DATE Date date 76 PER_ATTRIBUTE_CATEGORY LOV custom varchar2 80 Y select fdfcv.descriptive_flex_context_code id, fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=800 and fdfcv.descriptive_flexfield_name='PER_PEOPLE' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 77 PER_ATTRIBUTE1 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE1' 78 PER_ATTRIBUTE2 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE2' 79 PER_ATTRIBUTE3 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE3' 80 PER_ATTRIBUTE4 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE4' 81 PER_ATTRIBUTE5 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE5' 82 PER_ATTRIBUTE6 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE6' 83 PER_ATTRIBUTE7 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE7' 84 PER_ATTRIBUTE8 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE8' 85 PER_ATTRIBUTE9 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE9' 86 PER_ATTRIBUTE10 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE10' 87 PER_ATTRIBUTE11 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE11' 88 PER_ATTRIBUTE12 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE12' 89 PER_ATTRIBUTE13 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE13' 90 PER_ATTRIBUTE14 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE14' 91 PER_ATTRIBUTE15 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE15' 92 PER_ATTRIBUTE16 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE16', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE16' 93 PER_ATTRIBUTE17 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE17', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE17' 94 PER_ATTRIBUTE18 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE18', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE18' 95 PER_ATTRIBUTE19 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE19', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE19' 96 PER_ATTRIBUTE20 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE20', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE20' 97 PER_ATTRIBUTE21 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE21', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE21' 98 PER_ATTRIBUTE22 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE22', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE22' 99 PER_ATTRIBUTE23 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE23', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE23' 100 PER_ATTRIBUTE24 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE24', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE24' 101 PER_ATTRIBUTE25 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE25', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE25' 102 PER_ATTRIBUTE26 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE26', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE26' 103 PER_ATTRIBUTE27 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE27', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE27' 104 PER_ATTRIBUTE28 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE28', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE28' 105 PER_ATTRIBUTE29 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE29', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE29' 106 PER_ATTRIBUTE30 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=>'PER_PEOPLE', p_context_name=>:$column$.per_attribute_category, p_column_name=>'ATTRIBUTE30', p_attribute1=>:$column$.per_attribute1, p_attribute2=>:$column$.per_attribute2, p_attribute3=>:$column$.per_attribute3, p_attribute4=>:$column$.per_attribute4, p_attribute5=>:$column$.per_attribute5, p_attribute6=>:$column$.per_attribute6, p_attribute7=>:$column$.per_attribute7, p_attribute8=>:$column$.per_attribute8, p_attribute9=>:$column$.per_attribute9, p_attribute10=>:$column$.per_attribute10, p_attribute11=>:$column$.per_attribute11, p_attribute12=>:$column$.per_attribute12, p_attribute13=>:$column$.per_attribute13, p_attribute14=>:$column$.per_attribute14, p_attribute15=>:$column$.per_attribute15, p_attribute16=>:$column$.per_attribute16, p_attribute17=>:$column$.per_attribute17, p_attribute18=>:$column$.per_attribute18, p_attribute19=>:$column$.per_attribute19, p_attribute20=>:$column$.per_attribute20, p_attribute21=>:$column$.per_attribute21, p_attribute22=>:$column$.per_attribute22, p_attribute23=>:$column$.per_attribute23, p_attribute24=>:$column$.per_attribute24, p_attribute25=>:$column$.per_attribute25, p_attribute26=>:$column$.per_attribute26, p_attribute27=>:$column$.per_attribute27, p_attribute28=>:$column$.per_attribute28, p_attribute29=>:$column$.per_attribute29, p_attribute30=>:$column$.per_attribute30)) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '|| listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=800 and fdfc.descriptive_flexfield_name='PER_PEOPLE' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE30' 107 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 p_person_id_out in/out Number PERSON_ID_OUT U 3 p_business_group_id in Number BUSINESS_GROUP U 4 p_number in Char PERSON_NUMBER U 5 p_person_id in Number PERSON_ID U 6 p_last_name in Char LAST_NAME U 7 p_first_name in Char FIRST_NAME U 8 p_title in Char TITLE U 9 p_pre_name_adjunct in Char PREFIX U 10 p_suffix in Char SUFFIX U 11 p_middle_names in Char MIDDLE_NAMES U 12 p_sex in Char GENDER U 13 p_person_type_id in Number PERSON_TYPE U 14 p_national_identifier in Char NATIONAL_IDENTIFIER U 15 p_effective_date in Date EFFECTIVE_DATE U 16 p_datetrack_mode in Char DATETRACK_MODE U 17 p_latest_start_date in Date LATEST_START_DATE U 18 p_date_of_birth in Date BIRTH_DATE U 19 p_town_of_birth in Char TOWN_OF_BIRTH U 20 p_region_of_birth in Char REGION_OF_BIRTH U 21 p_country_of_birth in Char COUNTRY_OF_BIRTH U 22 p_marital_status in Char MARITAL_STATUS U 23 p_nationality in Char NATIONALITY U 24 p_registered_disabled_flag in Char REGISTERED_DISABLED U 25 p_per_information1 in Char PER_INFORMATION1 U 26 p_per_information2 in Char PER_INFORMATION2 U 27 p_per_information3 in Char PER_INFORMATION3 U 28 p_per_information4 in Char PER_INFORMATION4 U 29 p_per_information5 in Char PER_INFORMATION5 U 30 p_per_information6 in Char PER_INFORMATION6 U 31 p_per_information7 in Char PER_INFORMATION7 U 32 p_per_information8 in Char PER_INFORMATION8 U 33 p_per_information9 in Char PER_INFORMATION9 U 34 p_per_information10 in Char PER_INFORMATION10 U 35 p_per_information11 in Char PER_INFORMATION11 U 36 p_per_information12 in Char PER_INFORMATION12 U 37 p_per_information13 in Char PER_INFORMATION13 U 38 p_per_information14 in Char PER_INFORMATION14 U 39 p_per_information15 in Char PER_INFORMATION15 U 40 p_per_information16 in Char PER_INFORMATION16 U 41 p_per_information17 in Char PER_INFORMATION17 U 42 p_per_information18 in Char PER_INFORMATION18 U 43 p_per_information19 in Char PER_INFORMATION19 U 44 p_per_information20 in Char PER_INFORMATION20 U 45 p_per_information21 in Char PER_INFORMATION21 U 46 p_per_information22 in Char PER_INFORMATION22 U 47 p_per_information23 in Char PER_INFORMATION23 U 48 p_per_information24 in Char PER_INFORMATION24 U 49 p_per_information25 in Char PER_INFORMATION25 U 50 p_per_information26 in Char PER_INFORMATION26 U 51 p_per_information27 in Char PER_INFORMATION27 U 52 p_per_information28 in Char PER_INFORMATION28 U 53 p_per_information29 in Char PER_INFORMATION29 U 54 p_per_information30 in Char PER_INFORMATION30 U 55 p_office_number in Char OFFICE U 56 p_internal_location in Char LOCATION U 57 p_mailstop in Char MAILSTOP U 58 p_email_address in Char EMAIL U 59 p_mail_to in Char MAIL_TO U 60 p_honors in Char HONORS U 61 p_known_as in Char PREFERRED_NAME U 62 p_previous_last_name in Char PREVIOUS_LAST_NAME U 63 p_correspondence_language in Char CORRESPONDENCE_LANGUAGE U 64 p_date_employee_data_verified in Date DATE_LAST_VERIFIED U 65 p_student_status in Char STUDENT_STATUS U 66 p_on_military_service in Char ON_MILITARY_SERVICE U 67 p_second_passport_exists in Char SECOND_PASSPORT U 68 p_original_date_of_hire in Date DATE_FIRST_HIRED U 69 p_termination_date in Date TERMINATION_DATE U 70 p_leaving_reason in Char LEAVING_REASON U 71 p_final_process_date in Date FINAL_PROCESS_DATE U 72 p_per_attribute_category in Char PER_ATTRIBUTE_CATEGORY U 73 p_per_attribute1 in Char PER_ATTRIBUTE1 U 74 p_per_attribute2 in Char PER_ATTRIBUTE2 U 75 p_per_attribute3 in Char PER_ATTRIBUTE3 U 76 p_per_attribute4 in Char PER_ATTRIBUTE4 U 77 p_per_attribute5 in Char PER_ATTRIBUTE5 U 78 p_per_attribute6 in Char PER_ATTRIBUTE6 U 79 p_per_attribute7 in Char PER_ATTRIBUTE7 U 80 p_per_attribute8 in Char PER_ATTRIBUTE8 U 81 p_per_attribute9 in Char PER_ATTRIBUTE9 U 82 p_per_attribute10 in Char PER_ATTRIBUTE10 U 83 p_per_attribute11 in Char PER_ATTRIBUTE11 U 84 p_per_attribute12 in Char PER_ATTRIBUTE12 U 85 p_per_attribute13 in Char PER_ATTRIBUTE13 U 86 p_per_attribute14 in Char PER_ATTRIBUTE14 U 87 p_per_attribute15 in Char PER_ATTRIBUTE15 U 88 p_per_attribute16 in Char PER_ATTRIBUTE16 U 89 p_per_attribute17 in Char PER_ATTRIBUTE17 U 90 p_per_attribute18 in Char PER_ATTRIBUTE18 U 91 p_per_attribute19 in Char PER_ATTRIBUTE19 U 92 p_per_attribute20 in Char PER_ATTRIBUTE20 U 93 p_per_attribute21 in Char PER_ATTRIBUTE21 U 94 p_per_attribute22 in Char PER_ATTRIBUTE22 U 95 p_per_attribute23 in Char PER_ATTRIBUTE23 U 96 p_per_attribute24 in Char PER_ATTRIBUTE24 U 97 p_per_attribute25 in Char PER_ATTRIBUTE25 U 98 p_per_attribute26 in Char PER_ATTRIBUTE26 U 99 p_per_attribute27 in Char PER_ATTRIBUTE27 U 100 p_per_attribute28 in Char PER_ATTRIBUTE28 U 101 p_per_attribute29 in Char PER_ATTRIBUTE29 U 102 p_per_attribute30 in Char PER_ATTRIBUTE30 U 103 status_ out Char STATUS_CODE_ U 104 message_ out Char MESSAGE_ Error SQL Order By upload_row, business_group, person_number Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.person_id_out, nvl(papf.person_id,xu.person_id) person_id, nvl(pbg.name,xu.business_group) business_group, nvl(decode(xu.system_person_type,'CWK',papf.npw_number,'EX_CWK',papf.npw_number,'APL',papf.applicant_number,'EX_APL',papf.applicant_number,papf.employee_number),xu.person_number) person_number, nvl(papf.full_name,xu.full_name) full_name, nvl(papf.last_name,xu.last_name) last_name, nvl(papf.first_name,xu.first_name) first_name, nvl(xxen_util.meaning(papf.title,'TITLE',3),xu.title) title, nvl(papf.pre_name_adjunct,xu.prefix) prefix, nvl(papf.suffix,xu.suffix) suffix, nvl(papf.middle_names,xu.middle_names) middle_names, nvl(xxen_util.meaning(papf.sex,'SEX',3),xu.gender) gender, nvl(pptt.user_person_type,xu.person_type) person_type, nvl(papf.national_identifier,xu.national_identifier) national_identifier, xu.effective_date, xu.datetrack_mode, nvl(coalesce(ppos.date_start,ppop.date_start,papf.start_date),xu.latest_start_date) latest_start_date, nvl(papf.date_of_birth,xu.birth_date) birth_date, nvl(papf.town_of_birth,xu.town_of_birth) town_of_birth, nvl(papf.region_of_birth,xu.region_of_birth) region_of_birth, nvl((select ftv.territory_short_name from fnd_territories_vl ftv where papf.country_of_birth=ftv.territory_code),xu.country_of_birth) country_of_birth, nvl(xxen_util.meaning(papf.marital_status,'MAR_STATUS',3),xu.marital_status) marital_status, nvl(xxen_util.meaning(papf.nationality,'NATIONALITY',3),xu.nationality) nationality, nvl(xxen_util.meaning(papf.registered_disabled_flag,'REGISTERED_DISABLED',3),xu.registered_disabled) registered_disabled, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION1',papf.rowid,papf.per_information1),xu.per_information1) per_information1, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION2',papf.rowid,papf.per_information2),xu.per_information2) per_information2, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION3',papf.rowid,papf.per_information3),xu.per_information3) per_information3, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION4',papf.rowid,papf.per_information4),xu.per_information4) per_information4, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION5',papf.rowid,papf.per_information5),xu.per_information5) per_information5, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION6',papf.rowid,papf.per_information6),xu.per_information6) per_information6, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION7',papf.rowid,papf.per_information7),xu.per_information7) per_information7, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION8',papf.rowid,papf.per_information8),xu.per_information8) per_information8, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION9',papf.rowid,papf.per_information9),xu.per_information9) per_information9, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION10',papf.rowid,papf.per_information10),xu.per_information10) per_information10, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION11',papf.rowid,papf.per_information11),xu.per_information11) per_information11, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION12',papf.rowid,papf.per_information12),xu.per_information12) per_information12, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION13',papf.rowid,papf.per_information13),xu.per_information13) per_information13, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION14',papf.rowid,papf.per_information14),xu.per_information14) per_information14, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION15',papf.rowid,papf.per_information15),xu.per_information15) per_information15, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION16',papf.rowid,papf.per_information16),xu.per_information16) per_information16, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION17',papf.rowid,papf.per_information17),xu.per_information17) per_information17, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION18',papf.rowid,papf.per_information18),xu.per_information18) per_information18, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION19',papf.rowid,papf.per_information19),xu.per_information19) per_information19, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION20',papf.rowid,papf.per_information20),xu.per_information20) per_information20, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION21',papf.rowid,papf.per_information21),xu.per_information21) per_information21, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION22',papf.rowid,papf.per_information22),xu.per_information22) per_information22, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION23',papf.rowid,papf.per_information23),xu.per_information23) per_information23, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION24',papf.rowid,papf.per_information24),xu.per_information24) per_information24, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION25',papf.rowid,papf.per_information25),xu.per_information25) per_information25, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION26',papf.rowid,papf.per_information26),xu.per_information26) per_information26, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION27',papf.rowid,papf.per_information27),xu.per_information27) per_information27, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION28',papf.rowid,papf.per_information28),xu.per_information28) per_information28, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION29',papf.rowid,papf.per_information29),xu.per_information29) per_information29, nvl(xxen_util.display_flexfield_value(800,'Person Developer DF',papf.per_information_category,'PER_INFORMATION30',papf.rowid,papf.per_information30),xu.per_information30) per_information30, nvl(papf.office_number,xu.office) office, nvl(papf.internal_location,xu.location) location, nvl(papf.mailstop,xu.mailstop) mailstop, nvl(papf.email_address,xu.email) email, nvl(xxen_util.meaning(papf.expense_check_send_to_address,'HOME_OFFICE',3),xu.mail_to) mail_to, nvl(papf.honors,xu.honors) honors, nvl(papf.known_as,xu.preferred_name) preferred_name, nvl(papf.previous_last_name,xu.previous_last_name) previous_last_name, nvl((select flv.description from fnd_languages_vl flv where papf.correspondence_language=flv.language_code),xu.correspondence_language) correspondence_language, nvl(papf.date_employee_data_verified,xu.date_last_verified) date_last_verified, nvl(xxen_util.meaning(papf.student_status,'STUDENT_STATUS',3),xu.student_status) student_status, nvl(xxen_util.yes(papf.on_military_service),xu.on_military_service) on_military_service, nvl(xxen_util.yes(papf.second_passport_exists),xu.second_passport) second_passport, nvl(papf.original_date_of_hire,xu.date_first_hired) date_first_hired, nvl(nvl(ppos.actual_termination_date,ppop.actual_termination_date),xu.termination_date) termination_date, nvl(nvl(xxen_util.meaning(ppos.leaving_reason,'LEAV_REAS',3),xxen_util.meaning(ppop.termination_reason,'HR_CWK_TERMINATION_REASONS',3)),xu.leaving_reason) leaving_reason, nvl(nvl(ppos.final_process_date,ppop.final_process_date),xu.final_process_date) final_process_date, nvl(xxen_util.display_flexfield_context(800,'PER_PEOPLE',papf.attribute_category),xu.per_attribute_category) per_attribute_category, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE1',papf.rowid,papf.attribute1),xu.per_attribute1) per_attribute1, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE2',papf.rowid,papf.attribute2),xu.per_attribute2) per_attribute2, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE3',papf.rowid,papf.attribute3),xu.per_attribute3) per_attribute3, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE4',papf.rowid,papf.attribute4),xu.per_attribute4) per_attribute4, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE5',papf.rowid,papf.attribute5),xu.per_attribute5) per_attribute5, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE6',papf.rowid,papf.attribute6),xu.per_attribute6) per_attribute6, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE7',papf.rowid,papf.attribute7),xu.per_attribute7) per_attribute7, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE8',papf.rowid,papf.attribute8),xu.per_attribute8) per_attribute8, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE9',papf.rowid,papf.attribute9),xu.per_attribute9) per_attribute9, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE10',papf.rowid,papf.attribute10),xu.per_attribute10) per_attribute10, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE11',papf.rowid,papf.attribute11),xu.per_attribute11) per_attribute11, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE12',papf.rowid,papf.attribute12),xu.per_attribute12) per_attribute12, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE13',papf.rowid,papf.attribute13),xu.per_attribute13) per_attribute13, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE14',papf.rowid,papf.attribute14),xu.per_attribute14) per_attribute14, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE15',papf.rowid,papf.attribute15),xu.per_attribute15) per_attribute15, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE16',papf.rowid,papf.attribute16),xu.per_attribute16) per_attribute16, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE17',papf.rowid,papf.attribute17),xu.per_attribute17) per_attribute17, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE18',papf.rowid,papf.attribute18),xu.per_attribute18) per_attribute18, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE19',papf.rowid,papf.attribute19),xu.per_attribute19) per_attribute19, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE20',papf.rowid,papf.attribute20),xu.per_attribute20) per_attribute20, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE21',papf.rowid,papf.attribute21),xu.per_attribute21) per_attribute21, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE22',papf.rowid,papf.attribute22),xu.per_attribute22) per_attribute22, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE23',papf.rowid,papf.attribute23),xu.per_attribute23) per_attribute23, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE24',papf.rowid,papf.attribute24),xu.per_attribute24) per_attribute24, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE25',papf.rowid,papf.attribute25),xu.per_attribute25) per_attribute25, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE26',papf.rowid,papf.attribute26),xu.per_attribute26) per_attribute26, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE27',papf.rowid,papf.attribute27),xu.per_attribute27) per_attribute27, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE28',papf.rowid,papf.attribute28),xu.per_attribute28) per_attribute28, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE29',papf.rowid,papf.attribute29),xu.per_attribute29) per_attribute29, nvl(xxen_util.display_flexfield_value(800,'PER_PEOPLE',papf.attribute_category,'ATTRIBUTE30',papf.rowid,papf.attribute30),xu.per_attribute30) per_attribute30, xu.upload_row from ( select x.*, (select max(ppt.person_type_id) keep (dense_rank first order by decode(ppt.system_person_type,'EMP',1,'CWK',2,'APL',3,'EX_EMP',4,'EX_CWK',5,6)) from per_person_type_usages_f pptuf, per_person_types ppt where x.person_id_out=pptuf.person_id and x.row_date between pptuf.effective_start_date and pptuf.effective_end_date and pptuf.person_type_id=ppt.person_type_id and ppt.system_person_type in ('EMP','CWK','APL','EX_EMP','EX_CWK','EX_APL')) person_type_id, (select max(ppt.system_person_type) keep (dense_rank first order by decode(ppt.system_person_type,'EMP',1,'CWK',2,'APL',3,'EX_EMP',4,'EX_CWK',5,6)) from per_person_type_usages_f pptuf, per_person_types ppt where x.person_id_out=pptuf.person_id and x.row_date between pptuf.effective_start_date and pptuf.effective_end_date and pptuf.person_type_id=ppt.person_type_id and ppt.system_person_type in ('EMP','CWK','APL','EX_EMP','EX_CWK','EX_APL')) system_person_type from ( select xu.*, greatest(nvl(xu.effective_date,trunc(sysdate)),nvl(xu.latest_start_date,nvl(xu.effective_date,trunc(sysdate)))) row_date from xxen_per_person_upload_5950_u xu where xu.status_code_=xxen_upload.status_success ) x ) xu, per_all_people_f papf, per_business_groups pbg, per_person_types_tl pptt, ( select ppos.person_id, ppos.date_start, ppos.actual_termination_date, ppos.final_process_date, ppos.leaving_reason, row_number() over (partition by ppos.person_id order by ppos.date_start desc) rn from per_periods_of_service ppos where ppos.business_group_id=ppos.business_group_id ) ppos, ( select ppop.person_id, ppop.date_start, ppop.actual_termination_date, ppop.final_process_date, ppop.termination_reason, row_number() over (partition by ppop.person_id order by ppop.date_start desc) rn from per_periods_of_placement ppop where ppop.business_group_id=ppop.business_group_id ) ppop where xu.person_id_out=papf.person_id(+) and xu.row_date between papf.effective_start_date(+) and papf.effective_end_date(+) and papf.business_group_id=pbg.business_group_id(+) and xu.person_type_id=pptt.person_type_id(+) and pptt.language(+)=userenv('lang') and xu.person_id_out=ppos.person_id(+) and ppos.rn(+)=1 and xu.person_id_out=ppop.person_id(+) and ppop.rn(+)=1