ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN BFF169D4C79A4CC6BBDE8426071A730EY select null action_, null status_, null message_, null modified_columns_, to_number(null) previous_employer_id_out, to_number(null) previous_job_id_out, ppe.previous_employer_id, ppj.previous_job_id, pbg.name business_group, papf.employee_number, papf.full_name, ppe.employer_name employer, ppe.start_date employer_start_date, ppe.end_date employer_end_date, ppe.employer_address, (select ftv.territory_short_name from fnd_territories_vl ftv where ppe.employer_country=ftv.territory_code) employer_country, xxen_util.meaning(ppe.employer_type,'PREV_EMP_TYPE',3) employer_type, xxen_util.meaning(ppe.employer_subtype,'PREV_EMP_SUBTYPE',3) employer_subtype, ppe.period_years employer_years, ppe.period_months employer_months, ppe.period_days employer_days, ppe.description employer_description, xxen_util.yes(ppe.all_assignments) employer_all_assignments, null delete_employer, xxen_util.display_flexfield_context(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category) pem_attribute_category, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE1',ppe.rowid,ppe.pem_attribute1) pem_attribute1, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE2',ppe.rowid,ppe.pem_attribute2) pem_attribute2, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE3',ppe.rowid,ppe.pem_attribute3) pem_attribute3, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE4',ppe.rowid,ppe.pem_attribute4) pem_attribute4, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE5',ppe.rowid,ppe.pem_attribute5) pem_attribute5, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE6',ppe.rowid,ppe.pem_attribute6) pem_attribute6, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE7',ppe.rowid,ppe.pem_attribute7) pem_attribute7, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE8',ppe.rowid,ppe.pem_attribute8) pem_attribute8, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE9',ppe.rowid,ppe.pem_attribute9) pem_attribute9, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE10',ppe.rowid,ppe.pem_attribute10) pem_attribute10, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE11',ppe.rowid,ppe.pem_attribute11) pem_attribute11, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE12',ppe.rowid,ppe.pem_attribute12) pem_attribute12, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE13',ppe.rowid,ppe.pem_attribute13) pem_attribute13, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE14',ppe.rowid,ppe.pem_attribute14) pem_attribute14, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE15',ppe.rowid,ppe.pem_attribute15) pem_attribute15, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE16',ppe.rowid,ppe.pem_attribute16) pem_attribute16, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE17',ppe.rowid,ppe.pem_attribute17) pem_attribute17, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE18',ppe.rowid,ppe.pem_attribute18) pem_attribute18, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE19',ppe.rowid,ppe.pem_attribute19) pem_attribute19, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE20',ppe.rowid,ppe.pem_attribute20) pem_attribute20, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE21',ppe.rowid,ppe.pem_attribute21) pem_attribute21, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE22',ppe.rowid,ppe.pem_attribute22) pem_attribute22, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE23',ppe.rowid,ppe.pem_attribute23) pem_attribute23, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE24',ppe.rowid,ppe.pem_attribute24) pem_attribute24, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE25',ppe.rowid,ppe.pem_attribute25) pem_attribute25, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE26',ppe.rowid,ppe.pem_attribute26) pem_attribute26, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE27',ppe.rowid,ppe.pem_attribute27) pem_attribute27, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE28',ppe.rowid,ppe.pem_attribute28) pem_attribute28, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE29',ppe.rowid,ppe.pem_attribute29) pem_attribute29, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE30',ppe.rowid,ppe.pem_attribute30) pem_attribute30, ppj.start_date job_start_date, ppj.end_date job_end_date, ppj.job_name job, xxen_util.meaning(ppj.employment_category,'EMPLOYEE_CATG',3) employee_category, ppj.period_years job_years, ppj.period_months job_months, ppj.period_days job_days, ppj.description job_description, xxen_util.yes(ppj.all_assignments) job_all_assignments, null delete_job, xxen_util.display_flexfield_context(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category) pjo_attribute_category, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE1',ppj.rowid,ppj.pjo_attribute1) pjo_attribute1, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE2',ppj.rowid,ppj.pjo_attribute2) pjo_attribute2, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE3',ppj.rowid,ppj.pjo_attribute3) pjo_attribute3, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE4',ppj.rowid,ppj.pjo_attribute4) pjo_attribute4, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE5',ppj.rowid,ppj.pjo_attribute5) pjo_attribute5, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE6',ppj.rowid,ppj.pjo_attribute6) pjo_attribute6, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE7',ppj.rowid,ppj.pjo_attribute7) pjo_attribute7, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE8',ppj.rowid,ppj.pjo_attribute8) pjo_attribute8, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE9',ppj.rowid,ppj.pjo_attribute9) pjo_attribute9, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE10',ppj.rowid,ppj.pjo_attribute10) pjo_attribute10, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE11',ppj.rowid,ppj.pjo_attribute11) pjo_attribute11, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE12',ppj.rowid,ppj.pjo_attribute12) pjo_attribute12, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE13',ppj.rowid,ppj.pjo_attribute13) pjo_attribute13, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE14',ppj.rowid,ppj.pjo_attribute14) pjo_attribute14, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE15',ppj.rowid,ppj.pjo_attribute15) pjo_attribute15, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE16',ppj.rowid,ppj.pjo_attribute16) pjo_attribute16, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE17',ppj.rowid,ppj.pjo_attribute17) pjo_attribute17, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE18',ppj.rowid,ppj.pjo_attribute18) pjo_attribute18, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE19',ppj.rowid,ppj.pjo_attribute19) pjo_attribute19, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE20',ppj.rowid,ppj.pjo_attribute20) pjo_attribute20, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE21',ppj.rowid,ppj.pjo_attribute21) pjo_attribute21, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE22',ppj.rowid,ppj.pjo_attribute22) pjo_attribute22, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE23',ppj.rowid,ppj.pjo_attribute23) pjo_attribute23, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE24',ppj.rowid,ppj.pjo_attribute24) pjo_attribute24, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE25',ppj.rowid,ppj.pjo_attribute25) pjo_attribute25, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE26',ppj.rowid,ppj.pjo_attribute26) pjo_attribute26, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE27',ppj.rowid,ppj.pjo_attribute27) pjo_attribute27, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE28',ppj.rowid,ppj.pjo_attribute28) pjo_attribute28, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE29',ppj.rowid,ppj.pjo_attribute29) pjo_attribute29, xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE30',ppj.rowid,ppj.pjo_attribute30) pjo_attribute30, 0 upload_row from per_business_groups pbg, per_all_people_f papf, per_previous_employers ppe, per_previous_jobs ppj where 1=1 and pbg.business_group_id=:business_group_id and papf.business_group_id=pbg.business_group_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and papf.person_id=ppe.person_id and ppe.previous_employer_id=ppj.previous_employer_id(+) Initial version U A xxen_per_upload.create_update_prev_employment US PER Previous Employment Upload Upload to create, update and delete previous employment as in the Previous Employment window of the People form: previous employers with address, country, type, period of service and the Additional Previous Employer Details flexfield, and the jobs held there with employee category, period and the Additional Previous Job Details flexfield. Each row holds a previous employer and optionally one of its jobs; the employer columns repeat on every job row. A row is matched to an existing employer by the hidden id of a downloaded row, otherwise by employee, employer name and employer start date, and to an existing job by job name and start date within the employer. The assignment usages of previous jobs (Assignment Details region) are not part of the upload. Enginatics R12 only Upload 1=1 :business_group_id 1 10 1=1 :p_upload_mode like '%'||xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 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 FND Business Groups D7815153ACE3306DE0530100007FD65A select pbg.business_group_id id, pbg.name value, pbg.short_name description from per_business_groups pbg fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group 3 30 1=1 papf.employee_number=:employee_number LOV custom select papf.employee_number id, papf.employee_number value, papf.full_name description from per_all_people_f papf where papf.business_group_id=:$flex$.Business_Group and papf.employee_number is not null and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date order by papf.employee_number US Employee Number 4 40 1=1 upper(ppe.employer_name) like upper(:employer_name) Char US Employer like A2F8646ADE02423D9C625B7395C3C58A Create Previous Employment Empty sheet to record previous employers and jobs. ENGINATICS 24 BUSINESS_GROUP 18 EMPLOYEE_CATEGORY 1 EMPLOYEE_NUMBER 3 EMPLOYER Y 6 EMPLOYER_ADDRESS 14 EMPLOYER_ALL_ASSIGNMENTS 7 EMPLOYER_COUNTRY 12 EMPLOYER_DAYS 13 EMPLOYER_DESCRIPTION 5 EMPLOYER_END_DATE 11 EMPLOYER_MONTHS 4 EMPLOYER_START_DATE 9 EMPLOYER_SUBTYPE 8 EMPLOYER_TYPE 10 EMPLOYER_YEARS 2 FULL_NAME 17 JOB 23 JOB_ALL_ASSIGNMENTS 21 JOB_DAYS 22 JOB_DESCRIPTION 16 JOB_END_DATE 20 JOB_MONTHS 15 JOB_START_DATE 19 JOB_YEARS Upload Mode C Y S Site Employee Number Employer like 4FF559F0117449B6B0D88F9D69073328 Default Previous employers and their jobs as in the Previous Employment window, without the flexfields. ENGINATICS 26 BUSINESS_GROUP 15 DELETE_EMPLOYER 25 DELETE_JOB 19 EMPLOYEE_CATEGORY 1 EMPLOYEE_NUMBER 3 EMPLOYER Y 6 EMPLOYER_ADDRESS 14 EMPLOYER_ALL_ASSIGNMENTS 7 EMPLOYER_COUNTRY 12 EMPLOYER_DAYS 13 EMPLOYER_DESCRIPTION 5 EMPLOYER_END_DATE 11 EMPLOYER_MONTHS 4 EMPLOYER_START_DATE 9 EMPLOYER_SUBTYPE 8 EMPLOYER_TYPE 10 EMPLOYER_YEARS 2 FULL_NAME 18 JOB 24 JOB_ALL_ASSIGNMENTS 22 JOB_DAYS 23 JOB_DESCRIPTION 17 JOB_END_DATE 21 JOB_MONTHS 16 JOB_START_DATE 20 JOB_YEARS Upload Mode C,U S Site 6B296010A3B14074B98D39EA79D0B526 Flexfields Previous employer and job keys with the Additional Previous Employer and Previous Job Details flexfields. ENGINATICS 7 BUSINESS_GROUP 1 EMPLOYEE_NUMBER 3 EMPLOYER Y 4 EMPLOYER_START_DATE 2 FULL_NAME 5 JOB 6 JOB_START_DATE 9 PEM_ATTRIBUTE1 18 PEM_ATTRIBUTE10 19 PEM_ATTRIBUTE11 20 PEM_ATTRIBUTE12 21 PEM_ATTRIBUTE13 22 PEM_ATTRIBUTE14 23 PEM_ATTRIBUTE15 24 PEM_ATTRIBUTE16 25 PEM_ATTRIBUTE17 26 PEM_ATTRIBUTE18 27 PEM_ATTRIBUTE19 10 PEM_ATTRIBUTE2 28 PEM_ATTRIBUTE20 29 PEM_ATTRIBUTE21 30 PEM_ATTRIBUTE22 31 PEM_ATTRIBUTE23 32 PEM_ATTRIBUTE24 33 PEM_ATTRIBUTE25 34 PEM_ATTRIBUTE26 35 PEM_ATTRIBUTE27 36 PEM_ATTRIBUTE28 37 PEM_ATTRIBUTE29 11 PEM_ATTRIBUTE3 38 PEM_ATTRIBUTE30 12 PEM_ATTRIBUTE4 13 PEM_ATTRIBUTE5 14 PEM_ATTRIBUTE6 15 PEM_ATTRIBUTE7 16 PEM_ATTRIBUTE8 17 PEM_ATTRIBUTE9 8 PEM_ATTRIBUTE_CATEGORY 40 PJO_ATTRIBUTE1 49 PJO_ATTRIBUTE10 50 PJO_ATTRIBUTE11 51 PJO_ATTRIBUTE12 52 PJO_ATTRIBUTE13 53 PJO_ATTRIBUTE14 54 PJO_ATTRIBUTE15 55 PJO_ATTRIBUTE16 56 PJO_ATTRIBUTE17 57 PJO_ATTRIBUTE18 58 PJO_ATTRIBUTE19 41 PJO_ATTRIBUTE2 59 PJO_ATTRIBUTE20 60 PJO_ATTRIBUTE21 61 PJO_ATTRIBUTE22 62 PJO_ATTRIBUTE23 63 PJO_ATTRIBUTE24 64 PJO_ATTRIBUTE25 65 PJO_ATTRIBUTE26 66 PJO_ATTRIBUTE27 67 PJO_ATTRIBUTE28 68 PJO_ATTRIBUTE29 42 PJO_ATTRIBUTE3 69 PJO_ATTRIBUTE30 43 PJO_ATTRIBUTE4 44 PJO_ATTRIBUTE5 45 PJO_ATTRIBUTE6 46 PJO_ATTRIBUTE7 47 PJO_ATTRIBUTE8 48 PJO_ATTRIBUTE9 39 PJO_ATTRIBUTE_CATEGORY Upload Mode C,U S Site 4FF559F0117449B6B0D88F9D69073328 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 PREVIOUS_EMPLOYER_ID_OUT Number number Y 6 PREVIOUS_JOB_ID_OUT Number number Y 7 PREVIOUS_EMPLOYER_ID Number number Y 8 PREVIOUS_JOB_ID Number number Y 9 BUSINESS_GROUP LOV custom varchar2 240 select pbg.business_group_id id, pbg.name value, null description from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group order by pbg.name select pbg.name from per_business_groups pbg where pbg.business_group_id=:$flex$.Business_Group Y Y 10 EMPLOYEE_NUMBER LOV custom varchar2 30 Y select papf.employee_number id, papf.employee_number value, papf.full_name description from per_business_groups pbg, per_all_people_f papf where pbg.name=:$column$.business_group and papf.business_group_id=pbg.business_group_id and papf.employee_number is not null and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date order by papf.employee_number Y 11 FULL_NAME Char varchar2 240 select papf.full_name from per_business_groups pbg, per_all_people_f papf where pbg.name=:$column$.business_group and papf.business_group_id=pbg.business_group_id and papf.employee_number=:$column$.employee_number and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date Y 12 EMPLOYER Char varchar2 240 Y 13 EMPLOYER_START_DATE Date date 14 EMPLOYER_END_DATE Date date 15 EMPLOYER_ADDRESS Char varchar2 500 16 EMPLOYER_COUNTRY LOV custom varchar2 80 select ftv.territory_code id, ftv.territory_short_name value, null description from fnd_territories_vl ftv order by ftv.territory_short_name 17 EMPLOYER_TYPE LOV custom varchar2 80 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='PREV_EMP_TYPE' 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 18 EMPLOYER_SUBTYPE LOV custom varchar2 80 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='PREV_EMP_SUBTYPE' 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||'%') and flvv.lookup_code like (select flvv2.lookup_code from fnd_lookup_values_vl flvv2 where flvv2.lookup_type='PREV_EMP_TYPE' and flvv2.view_application_id=3 and flvv2.security_group_id=0 and flvv2.meaning=:$column$.employer_type)||'\_%' escape '\' order by flvv.meaning 19 EMPLOYER_YEARS Number number 20 EMPLOYER_MONTHS Number number 21 EMPLOYER_DAYS Number number 22 EMPLOYER_DESCRIPTION Char varchar2 2000 23 EMPLOYER_ALL_ASSIGNMENTS LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 24 DELETE_EMPLOYER LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Set to Yes to delete the previous employer together with its previous jobs. 25 PEM_ATTRIBUTE_CATEGORY LOV custom varchar2 80 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_PREVIOUS_EMPLOYERS' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 26 PEM_ATTRIBUTE1 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE1', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE1' 27 PEM_ATTRIBUTE2 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE2', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE2' 28 PEM_ATTRIBUTE3 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE3', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE3' 29 PEM_ATTRIBUTE4 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE4', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE4' 30 PEM_ATTRIBUTE5 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE5', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE5' 31 PEM_ATTRIBUTE6 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE6', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE6' 32 PEM_ATTRIBUTE7 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE7', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE7' 33 PEM_ATTRIBUTE8 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE8', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE8' 34 PEM_ATTRIBUTE9 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE9', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE9' 35 PEM_ATTRIBUTE10 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE10', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE10' 36 PEM_ATTRIBUTE11 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE11', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE11' 37 PEM_ATTRIBUTE12 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE12', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE12' 38 PEM_ATTRIBUTE13 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE13', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE13' 39 PEM_ATTRIBUTE14 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE14', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE14' 40 PEM_ATTRIBUTE15 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE15', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE15' 41 PEM_ATTRIBUTE16 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE16', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE16' 42 PEM_ATTRIBUTE17 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE17', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE17' 43 PEM_ATTRIBUTE18 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE18', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE18' 44 PEM_ATTRIBUTE19 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE19', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE19' 45 PEM_ATTRIBUTE20 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE20', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE20' 46 PEM_ATTRIBUTE21 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE21', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE21' 47 PEM_ATTRIBUTE22 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE22', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE22' 48 PEM_ATTRIBUTE23 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE23', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE23' 49 PEM_ATTRIBUTE24 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE24', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE24' 50 PEM_ATTRIBUTE25 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE25', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE25' 51 PEM_ATTRIBUTE26 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE26', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE26' 52 PEM_ATTRIBUTE27 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE27', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE27' 53 PEM_ATTRIBUTE28 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE28', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE28' 54 PEM_ATTRIBUTE29 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE29', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE29' 55 PEM_ATTRIBUTE30 LOV custom varchar2 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_PREVIOUS_EMPLOYERS', p_context_name=>:$column$.pem_attribute_category, p_column_name=>'PEM_ATTRIBUTE30', p_attribute1=>:$column$.pem_attribute1, p_attribute2=>:$column$.pem_attribute2, p_attribute3=>:$column$.pem_attribute3, p_attribute4=>:$column$.pem_attribute4, p_attribute5=>:$column$.pem_attribute5, p_attribute6=>:$column$.pem_attribute6, p_attribute7=>:$column$.pem_attribute7, p_attribute8=>:$column$.pem_attribute8, p_attribute9=>:$column$.pem_attribute9, p_attribute10=>:$column$.pem_attribute10, p_attribute11=>:$column$.pem_attribute11, p_attribute12=>:$column$.pem_attribute12, p_attribute13=>:$column$.pem_attribute13, p_attribute14=>:$column$.pem_attribute14, p_attribute15=>:$column$.pem_attribute15, p_attribute16=>:$column$.pem_attribute16, p_attribute17=>:$column$.pem_attribute17, p_attribute18=>:$column$.pem_attribute18, p_attribute19=>:$column$.pem_attribute19, p_attribute20=>:$column$.pem_attribute20, p_attribute21=>:$column$.pem_attribute21, p_attribute22=>:$column$.pem_attribute22, p_attribute23=>:$column$.pem_attribute23, p_attribute24=>:$column$.pem_attribute24, p_attribute25=>:$column$.pem_attribute25, p_attribute26=>:$column$.pem_attribute26, p_attribute27=>:$column$.pem_attribute27, p_attribute28=>:$column$.pem_attribute28, p_attribute29=>:$column$.pem_attribute29, p_attribute30=>:$column$.pem_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_PREVIOUS_EMPLOYERS' 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='PEM_ATTRIBUTE30' 56 JOB_START_DATE Date date 57 JOB_END_DATE Date date 58 JOB Char varchar2 240 Job held at the previous employer. Leave the job columns blank on a row that maintains the previous employer only. 59 EMPLOYEE_CATEGORY LOV custom varchar2 80 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='EMPLOYEE_CATG' 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 60 JOB_YEARS Number number 61 JOB_MONTHS Number number 62 JOB_DAYS Number number 63 JOB_DESCRIPTION Char varchar2 2000 64 JOB_ALL_ASSIGNMENTS LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 65 DELETE_JOB LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Set to Yes to delete the previous job. 66 PJO_ATTRIBUTE_CATEGORY LOV custom varchar2 80 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_PREVIOUS_JOBS' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 67 PJO_ATTRIBUTE1 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE1', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE1' 68 PJO_ATTRIBUTE2 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE2', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE2' 69 PJO_ATTRIBUTE3 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE3', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE3' 70 PJO_ATTRIBUTE4 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE4', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE4' 71 PJO_ATTRIBUTE5 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE5', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE5' 72 PJO_ATTRIBUTE6 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE6', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE6' 73 PJO_ATTRIBUTE7 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE7', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE7' 74 PJO_ATTRIBUTE8 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE8', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE8' 75 PJO_ATTRIBUTE9 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE9', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE9' 76 PJO_ATTRIBUTE10 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE10', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE10' 77 PJO_ATTRIBUTE11 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE11', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE11' 78 PJO_ATTRIBUTE12 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE12', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE12' 79 PJO_ATTRIBUTE13 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE13', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE13' 80 PJO_ATTRIBUTE14 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE14', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE14' 81 PJO_ATTRIBUTE15 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE15', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE15' 82 PJO_ATTRIBUTE16 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE16', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE16' 83 PJO_ATTRIBUTE17 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE17', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE17' 84 PJO_ATTRIBUTE18 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE18', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE18' 85 PJO_ATTRIBUTE19 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE19', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE19' 86 PJO_ATTRIBUTE20 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE20', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE20' 87 PJO_ATTRIBUTE21 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE21', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE21' 88 PJO_ATTRIBUTE22 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE22', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE22' 89 PJO_ATTRIBUTE23 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE23', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE23' 90 PJO_ATTRIBUTE24 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE24', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE24' 91 PJO_ATTRIBUTE25 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE25', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE25' 92 PJO_ATTRIBUTE26 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE26', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE26' 93 PJO_ATTRIBUTE27 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE27', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE27' 94 PJO_ATTRIBUTE28 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE28', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE28' 95 PJO_ATTRIBUTE29 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE29', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE29' 96 PJO_ATTRIBUTE30 LOV custom varchar2 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_PREVIOUS_JOBS', p_context_name=>:$column$.pjo_attribute_category, p_column_name=>'PJO_ATTRIBUTE30', p_attribute1=>:$column$.pjo_attribute1, p_attribute2=>:$column$.pjo_attribute2, p_attribute3=>:$column$.pjo_attribute3, p_attribute4=>:$column$.pjo_attribute4, p_attribute5=>:$column$.pjo_attribute5, p_attribute6=>:$column$.pjo_attribute6, p_attribute7=>:$column$.pjo_attribute7, p_attribute8=>:$column$.pjo_attribute8, p_attribute9=>:$column$.pjo_attribute9, p_attribute10=>:$column$.pjo_attribute10, p_attribute11=>:$column$.pjo_attribute11, p_attribute12=>:$column$.pjo_attribute12, p_attribute13=>:$column$.pjo_attribute13, p_attribute14=>:$column$.pjo_attribute14, p_attribute15=>:$column$.pjo_attribute15, p_attribute16=>:$column$.pjo_attribute16, p_attribute17=>:$column$.pjo_attribute17, p_attribute18=>:$column$.pjo_attribute18, p_attribute19=>:$column$.pjo_attribute19, p_attribute20=>:$column$.pjo_attribute20, p_attribute21=>:$column$.pjo_attribute21, p_attribute22=>:$column$.pjo_attribute22, p_attribute23=>:$column$.pjo_attribute23, p_attribute24=>:$column$.pjo_attribute24, p_attribute25=>:$column$.pjo_attribute25, p_attribute26=>:$column$.pjo_attribute26, p_attribute27=>:$column$.pjo_attribute27, p_attribute28=>:$column$.pjo_attribute28, p_attribute29=>:$column$.pjo_attribute29, p_attribute30=>:$column$.pjo_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_PREVIOUS_JOBS' 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='PJO_ATTRIBUTE30' 97 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 p_previous_employer_id_out in/out Number PREVIOUS_EMPLOYER_ID_OUT U 3 p_previous_job_id_out in/out Number PREVIOUS_JOB_ID_OUT U 4 p_business_group_id in Number BUSINESS_GROUP U 5 p_employee_number in Char EMPLOYEE_NUMBER U 6 p_previous_employer_id in Number Y PREVIOUS_EMPLOYER_ID U 7 p_previous_job_id in Number Y PREVIOUS_JOB_ID U 8 p_employer_name in Char Y EMPLOYER U 9 p_employer_start_date in Date Y EMPLOYER_START_DATE U 10 p_employer_end_date in Date Y EMPLOYER_END_DATE U 11 p_employer_address in Char Y EMPLOYER_ADDRESS U 12 p_employer_country in Char Y EMPLOYER_COUNTRY U 13 p_employer_type in Char Y EMPLOYER_TYPE U 14 p_employer_subtype in Char Y EMPLOYER_SUBTYPE U 15 p_employer_period_years in Number Y EMPLOYER_YEARS U 16 p_employer_period_months in Number Y EMPLOYER_MONTHS U 17 p_employer_period_days in Number Y EMPLOYER_DAYS U 18 p_employer_description in Char Y EMPLOYER_DESCRIPTION U 19 p_employer_all_assignments in Char Y EMPLOYER_ALL_ASSIGNMENTS U 20 p_delete_employer in Char Y DELETE_EMPLOYER U 21 p_pem_attribute_category in Char Y PEM_ATTRIBUTE_CATEGORY U 22 p_pem_attribute1 in Char Y PEM_ATTRIBUTE1 U 23 p_pem_attribute2 in Char Y PEM_ATTRIBUTE2 U 24 p_pem_attribute3 in Char Y PEM_ATTRIBUTE3 U 25 p_pem_attribute4 in Char Y PEM_ATTRIBUTE4 U 26 p_pem_attribute5 in Char Y PEM_ATTRIBUTE5 U 27 p_pem_attribute6 in Char Y PEM_ATTRIBUTE6 U 28 p_pem_attribute7 in Char Y PEM_ATTRIBUTE7 U 29 p_pem_attribute8 in Char Y PEM_ATTRIBUTE8 U 30 p_pem_attribute9 in Char Y PEM_ATTRIBUTE9 U 31 p_pem_attribute10 in Char Y PEM_ATTRIBUTE10 U 32 p_pem_attribute11 in Char Y PEM_ATTRIBUTE11 U 33 p_pem_attribute12 in Char Y PEM_ATTRIBUTE12 U 34 p_pem_attribute13 in Char Y PEM_ATTRIBUTE13 U 35 p_pem_attribute14 in Char Y PEM_ATTRIBUTE14 U 36 p_pem_attribute15 in Char Y PEM_ATTRIBUTE15 U 37 p_pem_attribute16 in Char Y PEM_ATTRIBUTE16 U 38 p_pem_attribute17 in Char Y PEM_ATTRIBUTE17 U 39 p_pem_attribute18 in Char Y PEM_ATTRIBUTE18 U 40 p_pem_attribute19 in Char Y PEM_ATTRIBUTE19 U 41 p_pem_attribute20 in Char Y PEM_ATTRIBUTE20 U 42 p_pem_attribute21 in Char Y PEM_ATTRIBUTE21 U 43 p_pem_attribute22 in Char Y PEM_ATTRIBUTE22 U 44 p_pem_attribute23 in Char Y PEM_ATTRIBUTE23 U 45 p_pem_attribute24 in Char Y PEM_ATTRIBUTE24 U 46 p_pem_attribute25 in Char Y PEM_ATTRIBUTE25 U 47 p_pem_attribute26 in Char Y PEM_ATTRIBUTE26 U 48 p_pem_attribute27 in Char Y PEM_ATTRIBUTE27 U 49 p_pem_attribute28 in Char Y PEM_ATTRIBUTE28 U 50 p_pem_attribute29 in Char Y PEM_ATTRIBUTE29 U 51 p_pem_attribute30 in Char Y PEM_ATTRIBUTE30 U 52 p_job_start_date in Date Y JOB_START_DATE U 53 p_job_end_date in Date Y JOB_END_DATE U 54 p_job_name in Char Y JOB U 55 p_employment_category in Char Y EMPLOYEE_CATEGORY U 56 p_job_period_years in Number Y JOB_YEARS U 57 p_job_period_months in Number Y JOB_MONTHS U 58 p_job_period_days in Number Y JOB_DAYS U 59 p_job_description in Char Y JOB_DESCRIPTION U 60 p_job_all_assignments in Char Y JOB_ALL_ASSIGNMENTS U 61 p_delete_job in Char Y DELETE_JOB U 62 p_pjo_attribute_category in Char Y PJO_ATTRIBUTE_CATEGORY U 63 p_pjo_attribute1 in Char Y PJO_ATTRIBUTE1 U 64 p_pjo_attribute2 in Char Y PJO_ATTRIBUTE2 U 65 p_pjo_attribute3 in Char Y PJO_ATTRIBUTE3 U 66 p_pjo_attribute4 in Char Y PJO_ATTRIBUTE4 U 67 p_pjo_attribute5 in Char Y PJO_ATTRIBUTE5 U 68 p_pjo_attribute6 in Char Y PJO_ATTRIBUTE6 U 69 p_pjo_attribute7 in Char Y PJO_ATTRIBUTE7 U 70 p_pjo_attribute8 in Char Y PJO_ATTRIBUTE8 U 71 p_pjo_attribute9 in Char Y PJO_ATTRIBUTE9 U 72 p_pjo_attribute10 in Char Y PJO_ATTRIBUTE10 U 73 p_pjo_attribute11 in Char Y PJO_ATTRIBUTE11 U 74 p_pjo_attribute12 in Char Y PJO_ATTRIBUTE12 U 75 p_pjo_attribute13 in Char Y PJO_ATTRIBUTE13 U 76 p_pjo_attribute14 in Char Y PJO_ATTRIBUTE14 U 77 p_pjo_attribute15 in Char Y PJO_ATTRIBUTE15 U 78 p_pjo_attribute16 in Char Y PJO_ATTRIBUTE16 U 79 p_pjo_attribute17 in Char Y PJO_ATTRIBUTE17 U 80 p_pjo_attribute18 in Char Y PJO_ATTRIBUTE18 U 81 p_pjo_attribute19 in Char Y PJO_ATTRIBUTE19 U 82 p_pjo_attribute20 in Char Y PJO_ATTRIBUTE20 U 83 p_pjo_attribute21 in Char Y PJO_ATTRIBUTE21 U 84 p_pjo_attribute22 in Char Y PJO_ATTRIBUTE22 U 85 p_pjo_attribute23 in Char Y PJO_ATTRIBUTE23 U 86 p_pjo_attribute24 in Char Y PJO_ATTRIBUTE24 U 87 p_pjo_attribute25 in Char Y PJO_ATTRIBUTE25 U 88 p_pjo_attribute26 in Char Y PJO_ATTRIBUTE26 U 89 p_pjo_attribute27 in Char Y PJO_ATTRIBUTE27 U 90 p_pjo_attribute28 in Char Y PJO_ATTRIBUTE28 U 91 p_pjo_attribute29 in Char Y PJO_ATTRIBUTE29 U 92 p_pjo_attribute30 in Char Y PJO_ATTRIBUTE30 U 93 status_ out Char STATUS_CODE_ U 94 message_ out Char MESSAGE_ Error SQL Order By upload_row, employee_number, employer_start_date, employer, job_start_date Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.previous_employer_id_out, xu.previous_job_id_out, nvl(ppe.previous_employer_id,xu.previous_employer_id) previous_employer_id, nvl(ppj.previous_job_id,xu.previous_job_id) previous_job_id, nvl(pbg.name,xu.business_group) business_group, nvl(papf.employee_number,xu.employee_number) employee_number, nvl(papf.full_name,xu.full_name) full_name, nvl(ppe.employer_name,xu.employer) employer, nvl(ppe.start_date,xu.employer_start_date) employer_start_date, nvl(ppe.end_date,xu.employer_end_date) employer_end_date, nvl(ppe.employer_address,xu.employer_address) employer_address, nvl((select ftv.territory_short_name from fnd_territories_vl ftv where ppe.employer_country=ftv.territory_code),xu.employer_country) employer_country, nvl(xxen_util.meaning(ppe.employer_type,'PREV_EMP_TYPE',3),xu.employer_type) employer_type, nvl(xxen_util.meaning(ppe.employer_subtype,'PREV_EMP_SUBTYPE',3),xu.employer_subtype) employer_subtype, nvl(ppe.period_years,xu.employer_years) employer_years, nvl(ppe.period_months,xu.employer_months) employer_months, nvl(ppe.period_days,xu.employer_days) employer_days, nvl(ppe.description,xu.employer_description) employer_description, nvl(xxen_util.yes(ppe.all_assignments),xu.employer_all_assignments) employer_all_assignments, xu.delete_employer, nvl(xxen_util.display_flexfield_context(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category),xu.pem_attribute_category) pem_attribute_category, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE1',ppe.rowid,ppe.pem_attribute1),xu.pem_attribute1) pem_attribute1, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE2',ppe.rowid,ppe.pem_attribute2),xu.pem_attribute2) pem_attribute2, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE3',ppe.rowid,ppe.pem_attribute3),xu.pem_attribute3) pem_attribute3, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE4',ppe.rowid,ppe.pem_attribute4),xu.pem_attribute4) pem_attribute4, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE5',ppe.rowid,ppe.pem_attribute5),xu.pem_attribute5) pem_attribute5, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE6',ppe.rowid,ppe.pem_attribute6),xu.pem_attribute6) pem_attribute6, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE7',ppe.rowid,ppe.pem_attribute7),xu.pem_attribute7) pem_attribute7, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE8',ppe.rowid,ppe.pem_attribute8),xu.pem_attribute8) pem_attribute8, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE9',ppe.rowid,ppe.pem_attribute9),xu.pem_attribute9) pem_attribute9, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE10',ppe.rowid,ppe.pem_attribute10),xu.pem_attribute10) pem_attribute10, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE11',ppe.rowid,ppe.pem_attribute11),xu.pem_attribute11) pem_attribute11, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE12',ppe.rowid,ppe.pem_attribute12),xu.pem_attribute12) pem_attribute12, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE13',ppe.rowid,ppe.pem_attribute13),xu.pem_attribute13) pem_attribute13, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE14',ppe.rowid,ppe.pem_attribute14),xu.pem_attribute14) pem_attribute14, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE15',ppe.rowid,ppe.pem_attribute15),xu.pem_attribute15) pem_attribute15, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE16',ppe.rowid,ppe.pem_attribute16),xu.pem_attribute16) pem_attribute16, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE17',ppe.rowid,ppe.pem_attribute17),xu.pem_attribute17) pem_attribute17, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE18',ppe.rowid,ppe.pem_attribute18),xu.pem_attribute18) pem_attribute18, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE19',ppe.rowid,ppe.pem_attribute19),xu.pem_attribute19) pem_attribute19, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE20',ppe.rowid,ppe.pem_attribute20),xu.pem_attribute20) pem_attribute20, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE21',ppe.rowid,ppe.pem_attribute21),xu.pem_attribute21) pem_attribute21, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE22',ppe.rowid,ppe.pem_attribute22),xu.pem_attribute22) pem_attribute22, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE23',ppe.rowid,ppe.pem_attribute23),xu.pem_attribute23) pem_attribute23, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE24',ppe.rowid,ppe.pem_attribute24),xu.pem_attribute24) pem_attribute24, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE25',ppe.rowid,ppe.pem_attribute25),xu.pem_attribute25) pem_attribute25, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE26',ppe.rowid,ppe.pem_attribute26),xu.pem_attribute26) pem_attribute26, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE27',ppe.rowid,ppe.pem_attribute27),xu.pem_attribute27) pem_attribute27, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE28',ppe.rowid,ppe.pem_attribute28),xu.pem_attribute28) pem_attribute28, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE29',ppe.rowid,ppe.pem_attribute29),xu.pem_attribute29) pem_attribute29, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_EMPLOYERS',ppe.pem_attribute_category,'PEM_ATTRIBUTE30',ppe.rowid,ppe.pem_attribute30),xu.pem_attribute30) pem_attribute30, nvl(ppj.start_date,xu.job_start_date) job_start_date, nvl(ppj.end_date,xu.job_end_date) job_end_date, nvl(ppj.job_name,xu.job) job, nvl(xxen_util.meaning(ppj.employment_category,'EMPLOYEE_CATG',3),xu.employee_category) employee_category, nvl(ppj.period_years,xu.job_years) job_years, nvl(ppj.period_months,xu.job_months) job_months, nvl(ppj.period_days,xu.job_days) job_days, nvl(ppj.description,xu.job_description) job_description, nvl(xxen_util.yes(ppj.all_assignments),xu.job_all_assignments) job_all_assignments, xu.delete_job, nvl(xxen_util.display_flexfield_context(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category),xu.pjo_attribute_category) pjo_attribute_category, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE1',ppj.rowid,ppj.pjo_attribute1),xu.pjo_attribute1) pjo_attribute1, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE2',ppj.rowid,ppj.pjo_attribute2),xu.pjo_attribute2) pjo_attribute2, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE3',ppj.rowid,ppj.pjo_attribute3),xu.pjo_attribute3) pjo_attribute3, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE4',ppj.rowid,ppj.pjo_attribute4),xu.pjo_attribute4) pjo_attribute4, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE5',ppj.rowid,ppj.pjo_attribute5),xu.pjo_attribute5) pjo_attribute5, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE6',ppj.rowid,ppj.pjo_attribute6),xu.pjo_attribute6) pjo_attribute6, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE7',ppj.rowid,ppj.pjo_attribute7),xu.pjo_attribute7) pjo_attribute7, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE8',ppj.rowid,ppj.pjo_attribute8),xu.pjo_attribute8) pjo_attribute8, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE9',ppj.rowid,ppj.pjo_attribute9),xu.pjo_attribute9) pjo_attribute9, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE10',ppj.rowid,ppj.pjo_attribute10),xu.pjo_attribute10) pjo_attribute10, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE11',ppj.rowid,ppj.pjo_attribute11),xu.pjo_attribute11) pjo_attribute11, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE12',ppj.rowid,ppj.pjo_attribute12),xu.pjo_attribute12) pjo_attribute12, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE13',ppj.rowid,ppj.pjo_attribute13),xu.pjo_attribute13) pjo_attribute13, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE14',ppj.rowid,ppj.pjo_attribute14),xu.pjo_attribute14) pjo_attribute14, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE15',ppj.rowid,ppj.pjo_attribute15),xu.pjo_attribute15) pjo_attribute15, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE16',ppj.rowid,ppj.pjo_attribute16),xu.pjo_attribute16) pjo_attribute16, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE17',ppj.rowid,ppj.pjo_attribute17),xu.pjo_attribute17) pjo_attribute17, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE18',ppj.rowid,ppj.pjo_attribute18),xu.pjo_attribute18) pjo_attribute18, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE19',ppj.rowid,ppj.pjo_attribute19),xu.pjo_attribute19) pjo_attribute19, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE20',ppj.rowid,ppj.pjo_attribute20),xu.pjo_attribute20) pjo_attribute20, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE21',ppj.rowid,ppj.pjo_attribute21),xu.pjo_attribute21) pjo_attribute21, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE22',ppj.rowid,ppj.pjo_attribute22),xu.pjo_attribute22) pjo_attribute22, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE23',ppj.rowid,ppj.pjo_attribute23),xu.pjo_attribute23) pjo_attribute23, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE24',ppj.rowid,ppj.pjo_attribute24),xu.pjo_attribute24) pjo_attribute24, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE25',ppj.rowid,ppj.pjo_attribute25),xu.pjo_attribute25) pjo_attribute25, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE26',ppj.rowid,ppj.pjo_attribute26),xu.pjo_attribute26) pjo_attribute26, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE27',ppj.rowid,ppj.pjo_attribute27),xu.pjo_attribute27) pjo_attribute27, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE28',ppj.rowid,ppj.pjo_attribute28),xu.pjo_attribute28) pjo_attribute28, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE29',ppj.rowid,ppj.pjo_attribute29),xu.pjo_attribute29) pjo_attribute29, nvl(xxen_util.display_flexfield_value(800,'PER_PREVIOUS_JOBS',ppj.pjo_attribute_category,'PJO_ATTRIBUTE30',ppj.rowid,ppj.pjo_attribute30),xu.pjo_attribute30) pjo_attribute30, xu.upload_row from xxen_per_previous_emplo_5106_u xu, per_previous_employers ppe, per_previous_jobs ppj, per_all_people_f papf, per_business_groups pbg where xu.status_code_=xxen_upload.status_success and xu.previous_employer_id_out=ppe.previous_employer_id(+) and xu.previous_job_id_out=ppj.previous_job_id(+) and ppe.person_id=papf.person_id(+) and trunc(sysdate) between papf.effective_start_date(+) and papf.effective_end_date(+) and papf.business_group_id=pbg.business_group_id(+)