ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 3E3B18F6A8CC441991CED52EBA6FC31FY select null action_, null status_, null message_, null modified_columns_, to_number(null) element_link_id_out, pelf.element_link_id, pbg.name business_group, petfv.element_name, petfv.description element_description, (select pecv.classification_name from pay_element_classifications_vl pecv where petfv.classification_id=pecv.classification_id) classification, xxen_util.meaning(petfv.processing_type,'PROCESSING_TYPE',3) processing_type, xxen_util.yes(pelf.standard_link_flag) standard, :effective_date effective_date, null datetrack_mode, (select min(pelf2.effective_start_date) from pay_element_links_f pelf2 where pelf.element_link_id=pelf2.element_link_id) start_date, (select nullif(max(pelf2.effective_end_date),to_date('31-12-4712','DD-MM-YYYY')) from pay_element_links_f pelf2 where pelf.element_link_id=pelf2.element_link_id) end_date, (select haouv.name from hr_all_organization_units_vl haouv where pelf.organization_id=haouv.organization_id) organization, (select pjv.name from per_jobs_vl pjv where pelf.job_id=pjv.job_id) job, (select hpf.name from hr_positions_f hpf where pelf.position_id=hpf.position_id and :effective_date between hpf.effective_start_date and hpf.effective_end_date) position, (select pgv.name from per_grades_vl pgv where pelf.grade_id=pgv.grade_id) grade, (select ppg.group_name from pay_people_groups ppg where pelf.people_group_id=ppg.people_group_id) people_group, (select hlav.location_code from hr_locations_all_vl hlav where pelf.location_id=hlav.location_id) location, (select ppb.name from per_pay_bases ppb where pelf.pay_basis_id=ppb.pay_basis_id) salary_basis, xxen_util.meaning(pelf.employment_category,'EMP_CAT',3) employment_category, (select papf.payroll_name from pay_all_payrolls_f papf where pelf.payroll_id=papf.payroll_id and :effective_date between papf.effective_start_date and papf.effective_end_date) payroll, xxen_util.yes(pelf.link_to_all_payrolls_flag) link_to_all_payrolls, xxen_util.meaning(pelf.costable_type,'COSTABLE_TYPE',3) costable_type, xxen_util.yes(pelf.transfer_to_gl_flag) transfer_to_gl, (select pes.element_set_name from pay_element_sets pes where pelf.element_set_id=pes.element_set_id) distribution_set, xxen_hr_upload.cost_keyflex_dsp(pelf.cost_allocation_keyflex_id,'ELEMENT') costing, xxen_hr_upload.cost_keyflex_dsp(pelf.balancing_keyflex_id,'BALANCING') balancing, pelf.qualifying_age, pelf.qualifying_length_of_service, xxen_util.meaning(pelf.qualifying_units,'QUALIFYING_UNITS',3) qualifying_units, xxen_util.display_flexfield_context(801,'PAY_ELEMENT_LINKS',pelf.attribute_category) link_attribute_category, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE1',pelf.rowid,pelf.attribute1) link_attribute1, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE2',pelf.rowid,pelf.attribute2) link_attribute2, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE3',pelf.rowid,pelf.attribute3) link_attribute3, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE4',pelf.rowid,pelf.attribute4) link_attribute4, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE5',pelf.rowid,pelf.attribute5) link_attribute5, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE6',pelf.rowid,pelf.attribute6) link_attribute6, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE7',pelf.rowid,pelf.attribute7) link_attribute7, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE8',pelf.rowid,pelf.attribute8) link_attribute8, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE9',pelf.rowid,pelf.attribute9) link_attribute9, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE10',pelf.rowid,pelf.attribute10) link_attribute10, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE11',pelf.rowid,pelf.attribute11) link_attribute11, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE12',pelf.rowid,pelf.attribute12) link_attribute12, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE13',pelf.rowid,pelf.attribute13) link_attribute13, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE14',pelf.rowid,pelf.attribute14) link_attribute14, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE15',pelf.rowid,pelf.attribute15) link_attribute15, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE16',pelf.rowid,pelf.attribute16) link_attribute16, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE17',pelf.rowid,pelf.attribute17) link_attribute17, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE18',pelf.rowid,pelf.attribute18) link_attribute18, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE19',pelf.rowid,pelf.attribute19) link_attribute19, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE20',pelf.rowid,pelf.attribute20) link_attribute20, 0 upload_row from per_business_groups pbg, pay_element_links_f pelf, pay_element_types_f_vl petfv where 1=1 and pbg.business_group_id=:business_group_id and pbg.business_group_id=pelf.business_group_id and :effective_date between pelf.effective_start_date and pelf.effective_end_date and pelf.element_type_id=petfv.element_type_id and :effective_date between petfv.effective_start_date and petfv.effective_end_date Initial version - create, update and end date element links with their eligibility criteria, costing and qualifying conditions through pay_element_link_api U A xxen_hr_upload.create_update_element_link US PER Payroll Element Link Upload Upload to create, update and end date element links as in the Element Link form: the element, the eligibility criteria (organization, job, position, grade, people group, location, salary basis, employment category, payroll or all payrolls), standard link, costing, qualifying conditions and the Further Information flexfield. Changes are made as of the Effective Date. When Datetrack Mode is blank, the link is corrected if the Effective Date is the start date of its current record, and otherwise a change is inserted from the Effective Date (Update, or Update - Insert when later changes exist). The element and the eligibility criteria of an existing link cannot be changed, as in the form. A new row with the criteria of an existing link of the element updates that link. Entering an End Date end dates the link on that date, clearing it removes the end date. Costing and Balancing take the segment values the form shows (segments enabled for the Element and Balancing levels), separated by the flexfield delimiter. People Group takes the concatenated segment values. New combinations are created as needed. Link input values are not maintained by this upload. Enginatics R12 only Upload 1=1 :business_group_id :effective_date 1 10 1=1 :p_upload_mode like '%'||xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 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 :effective_date Date trunc(sysdate) Y US Effective Date Date the downloaded links are shown as of and the default date the uploaded changes take effect. 4 40 1=1 petfv.element_name=:element_name LOV custom select distinct petfv.element_name value, (select pecv.classification_name from pay_element_classifications_vl pecv where petfv.classification_id=pecv.classification_id) description from pay_element_links_f pelf, pay_element_types_f_vl petfv where pelf.business_group_id=:$flex$.Business_Group and pelf.element_type_id=petfv.element_type_id and trunc(sysdate) between petfv.effective_start_date and petfv.effective_end_date order by petfv.element_name US Element Name 5 50 1=1 petfv.classification_id=:classification_id LOV custom select pecv.classification_id id, pecv.classification_name value, null description from per_business_groups pbg, pay_element_classifications_vl pecv where pbg.business_group_id=:$flex$.Business_Group and (pecv.business_group_id=pbg.business_group_id or pecv.business_group_id is null and pecv.legislation_code=pbg.legislation_code) order by pecv.classification_name US Classification 6 60 1=1 pelf.organization_id=:organization_id LOV custom select haouv.organization_id id, haouv.name value, null description from hr_all_organization_units_vl haouv where haouv.business_group_id=:$flex$.Business_Group order by haouv.name US Organization 7 70 1=1 pelf.payroll_id=:payroll_id LOV custom select distinct papf.payroll_id id, papf.payroll_name value, null description from pay_all_payrolls_f papf where papf.business_group_id=:$flex$.Business_Group order by papf.payroll_name US Payroll 8 80 1=1 pelf.costable_type=:costable_type LOV custom select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='COSTABLE_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning US Costable Type 6C46248BCD1C4698A68A2F69A21F7BE9 Costing Changes the costable type, distribution set and the costing and balancing segments of existing links. ENGINATICS 13 BALANCING 1 BUSINESS_GROUP 9 COSTABLE_TYPE 12 COSTING 8 DATETRACK_MODE 11 DISTRIBUTION_SET 7 EFFECTIVE_DATE Y 2 ELEMENT_NAME 6 LINK_TO_ALL_PAYROLLS 3 ORGANIZATION 5 PAYROLL 4 PEOPLE_GROUP 10 TRANSFER_TO_GL Upload Mode C,U S Site 03AC8B78D46C404D906BCA03FA48CEED Create Element Links Opens an empty sheet to create new element links. ENGINATICS 23 BALANCING 1 BUSINESS_GROUP 4 CLASSIFICATION 19 COSTABLE_TYPE 22 COSTING 21 DISTRIBUTION_SET 7 EFFECTIVE_DATE 3 ELEMENT_DESCRIPTION Y 2 ELEMENT_NAME 16 EMPLOYMENT_CATEGORY 8 END_DATE 12 GRADE 10 JOB 18 LINK_TO_ALL_PAYROLLS 14 LOCATION 9 ORGANIZATION 17 PAYROLL 13 PEOPLE_GROUP 11 POSITION 5 PROCESSING_TYPE 24 QUALIFYING_AGE 25 QUALIFYING_LENGTH_OF_SERVICE 26 QUALIFYING_UNITS 15 SALARY_BASIS 6 STANDARD 20 TRANSFER_TO_GL Upload Mode C Y S Site Classification Costable Type Element Name Organization Payroll 8FEE33A312B24E8BBC3E466712A291AD Default Creates, updates and end dates element links with the fields of the Element Link form, without the flexfield. ENGINATICS 25 BALANCING 1 BUSINESS_GROUP 4 CLASSIFICATION 21 COSTABLE_TYPE 24 COSTING 8 DATETRACK_MODE 23 DISTRIBUTION_SET 7 EFFECTIVE_DATE 3 ELEMENT_DESCRIPTION Y 2 ELEMENT_NAME 18 EMPLOYMENT_CATEGORY 10 END_DATE 14 GRADE 12 JOB 20 LINK_TO_ALL_PAYROLLS 16 LOCATION 11 ORGANIZATION 19 PAYROLL 15 PEOPLE_GROUP 13 POSITION 5 PROCESSING_TYPE 26 QUALIFYING_AGE 27 QUALIFYING_LENGTH_OF_SERVICE 28 QUALIFYING_UNITS 17 SALARY_BASIS 6 STANDARD 9 START_DATE 22 TRANSFER_TO_GL Upload Mode C,U S Site 6607B2D6A3924ABF9622E9733BFFB244 End Date End dates existing links, or removes their end date. ENGINATICS 1 BUSINESS_GROUP 2 ELEMENT_NAME 10 EMPLOYMENT_CATEGORY 14 END_DATE 6 GRADE 4 JOB 12 LINK_TO_ALL_PAYROLLS 8 LOCATION 3 ORGANIZATION Y 11 PAYROLL 7 PEOPLE_GROUP 5 POSITION 9 SALARY_BASIS 13 START_DATE Upload Mode C,U S Site 0EB1C46DAD4E43568AABF0AF5E64334B Further Information Maintains the Further Information flexfield of existing links. ENGINATICS 1 BUSINESS_GROUP 8 DATETRACK_MODE 7 EFFECTIVE_DATE Y 2 ELEMENT_NAME 10 LINK_ATTRIBUTE1 19 LINK_ATTRIBUTE10 20 LINK_ATTRIBUTE11 21 LINK_ATTRIBUTE12 22 LINK_ATTRIBUTE13 23 LINK_ATTRIBUTE14 24 LINK_ATTRIBUTE15 25 LINK_ATTRIBUTE16 26 LINK_ATTRIBUTE17 27 LINK_ATTRIBUTE18 28 LINK_ATTRIBUTE19 11 LINK_ATTRIBUTE2 29 LINK_ATTRIBUTE20 12 LINK_ATTRIBUTE3 13 LINK_ATTRIBUTE4 14 LINK_ATTRIBUTE5 15 LINK_ATTRIBUTE6 16 LINK_ATTRIBUTE7 17 LINK_ATTRIBUTE8 18 LINK_ATTRIBUTE9 9 LINK_ATTRIBUTE_CATEGORY 6 LINK_TO_ALL_PAYROLLS 3 ORGANIZATION 5 PAYROLL 4 PEOPLE_GROUP Upload Mode C,U S Site 8FEE33A312B24E8BBC3E466712A291AD 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 ELEMENT_LINK_ID_OUT Number number Y 6 ELEMENT_LINK_ID Number number Y 7 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 8 ELEMENT_NAME LOV custom varchar2 80 select petfv.element_type_id id, petfv.element_name value, pecv.classification_name description from per_business_groups pbg, pay_element_types_f_vl petfv, pay_element_classifications_vl pecv where pbg.name=:$column$.business_group and (petfv.business_group_id=pbg.business_group_id or petfv.business_group_id is null and petfv.legislation_code=pbg.legislation_code) and nvl(:$column$.effective_date,trunc(sysdate)) between petfv.effective_start_date and petfv.effective_end_date and petfv.classification_id=pecv.classification_id order by petfv.element_name Y Y 9 ELEMENT_DESCRIPTION Char varchar2 240 select petfv.description from per_business_groups pbg, pay_element_types_f_vl petfv where pbg.name=:$column$.business_group and (petfv.business_group_id=pbg.business_group_id or petfv.business_group_id is null and petfv.legislation_code=pbg.legislation_code) and petfv.element_name=:$column$.element_name and nvl(:$column$.effective_date,trunc(sysdate)) between petfv.effective_start_date and petfv.effective_end_date Y 10 CLASSIFICATION Char varchar2 80 select (select pecv.classification_name from pay_element_classifications_vl pecv where petfv.classification_id=pecv.classification_id) from per_business_groups pbg, pay_element_types_f_vl petfv where pbg.name=:$column$.business_group and (petfv.business_group_id=pbg.business_group_id or petfv.business_group_id is null and petfv.legislation_code=pbg.legislation_code) and petfv.element_name=:$column$.element_name and nvl(:$column$.effective_date,trunc(sysdate)) between petfv.effective_start_date and petfv.effective_end_date Y 11 PROCESSING_TYPE Char varchar2 80 select xxen_util.meaning(petfv.processing_type,'PROCESSING_TYPE',3) from per_business_groups pbg, pay_element_types_f_vl petfv where pbg.name=:$column$.business_group and (petfv.business_group_id=pbg.business_group_id or petfv.business_group_id is null and petfv.legislation_code=pbg.legislation_code) and petfv.element_name=:$column$.element_name and nvl(:$column$.effective_date,trunc(sysdate)) between petfv.effective_start_date and petfv.effective_end_date Y 12 STANDARD LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_util.yes(petfv.standard_link_flag) from per_business_groups pbg, pay_element_types_f_vl petfv where pbg.name=:$column$.business_group and (petfv.business_group_id=pbg.business_group_id or petfv.business_group_id is null and petfv.legislation_code=pbg.legislation_code) and petfv.element_name=:$column$.element_name and nvl(:$column$.effective_date,trunc(sysdate)) between petfv.effective_start_date and petfv.effective_end_date Creates entries of the element automatically for every assignment eligible for the link. Recurring elements only. 13 EFFECTIVE_DATE Date date :$flex$.Effective_Date Date a new link starts and the changes of an existing link take effect. Defaults from the Effective Date parameter. 14 DATETRACK_MODE LOV varchar2 80 PER Datetrack Mode C2B369C438934DD881605CB3FC10EF14 select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='PQH_DT_MODE' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and flvv.lookup_code in ('CORRECTION','UPDATE','UPDATE_CHANGE_INSERT','UPDATE_OVERRIDE') order by flvv.meaning Leave blank to correct the link when the Effective Date is the start date of its current record and to insert a change otherwise. 15 START_DATE Date date Y 16 END_DATE Date date Last day of the link. Entering a date end dates the link, clearing it removes the end date. 17 ORGANIZATION LOV custom varchar2 240 select haouv.organization_id id, haouv.name value, null description from per_business_groups pbg, hr_all_organization_units_vl haouv where pbg.name=:$column$.business_group and haouv.business_group_id=pbg.business_group_id and haouv.internal_external_flag='INT' and nvl(:$column$.effective_date,trunc(sysdate)) between haouv.date_from and nvl(haouv.date_to,nvl(:$column$.effective_date,trunc(sysdate))) and haouv.organization_id in (select hoi.organization_id from hr_organization_information hoi where hoi.org_information_context='CLASS' and hoi.org_information1 in ('HR_ORG','HR_BG') and hoi.org_information2='Y') order by haouv.name Y 18 JOB LOV custom varchar2 240 select pjv.job_id id, pjv.name value, null description from per_business_groups pbg, per_jobs_vl pjv where pbg.name=:$column$.business_group and pjv.business_group_id=pbg.business_group_id and nvl(:$column$.effective_date,trunc(sysdate)) between pjv.date_from and nvl(pjv.date_to,nvl(:$column$.effective_date,trunc(sysdate))) order by pjv.name Y 19 POSITION LOV custom varchar2 240 select hpf.position_id id, hpf.name value, null description from per_business_groups pbg, hr_positions_f hpf where pbg.name=:$column$.business_group and hpf.business_group_id=pbg.business_group_id and nvl(:$column$.effective_date,trunc(sysdate)) between hpf.effective_start_date and hpf.effective_end_date order by hpf.name Y 20 GRADE LOV custom varchar2 240 select pgv.grade_id id, pgv.name value, null description from per_business_groups pbg, per_grades_vl pgv where pbg.name=:$column$.business_group and pgv.business_group_id=pbg.business_group_id and nvl(:$column$.effective_date,trunc(sysdate)) between pgv.date_from and nvl(pgv.date_to,nvl(:$column$.effective_date,trunc(sysdate))) order by pgv.name Y 21 PEOPLE_GROUP LOV custom varchar2 240 Y select distinct ppg.group_name value, null description from per_business_groups pbg, pay_people_groups ppg where pbg.name=:$column$.business_group and ppg.id_flex_num=to_number(pbg.people_group_structure) and ppg.enabled_flag='Y' order by ppg.group_name Concatenated segment values of the People Group flexfield. A new combination is created when it does not exist. Y 22 LOCATION LOV custom varchar2 60 select hlav.location_id id, hlav.location_code value, hlav.description from per_business_groups pbg, hr_locations_all_vl hlav where pbg.name=:$column$.business_group and nvl(hlav.business_group_id,pbg.business_group_id)=pbg.business_group_id and (hlav.inactive_date is null or hlav.inactive_date>nvl(:$column$.effective_date,trunc(sysdate))) order by hlav.location_code Y 23 SALARY_BASIS LOV custom varchar2 80 select ppb.pay_basis_id id, ppb.name value, null description from per_business_groups pbg, per_pay_bases ppb where pbg.name=:$column$.business_group and ppb.business_group_id=pbg.business_group_id order by ppb.name Y 24 EMPLOYMENT_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='EMP_CAT' 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 Y 25 PAYROLL LOV custom varchar2 80 select papf.payroll_id id, papf.payroll_name value, null description from per_business_groups pbg, pay_all_payrolls_f papf where pbg.name=:$column$.business_group and papf.business_group_id=pbg.business_group_id and nvl(:$column$.effective_date,trunc(sysdate)) between papf.effective_start_date and papf.effective_end_date order by papf.payroll_name Y 26 LINK_TO_ALL_PAYROLLS LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y 27 COSTABLE_TYPE LOV custom varchar2 80 select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='COSTABLE_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning xxen_util.meaning('N','COSTABLE_TYPE',3) Y 28 TRANSFER_TO_GL LOV varchar2 80 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 29 DISTRIBUTION_SET LOV custom varchar2 80 select pes.element_set_id id, pes.element_set_name value, null description from per_business_groups pbg, pay_element_sets pes where pbg.name=:$column$.business_group and pes.element_set_type='D' and (pes.business_group_id=pbg.business_group_id or pes.business_group_id is null and pes.legislation_code=pbg.legislation_code) order by pes.element_set_name Required for a Distributed costable type. 30 COSTING LOV custom varchar2 2000 Y select distinct xxen_hr_upload.cost_keyflex_dsp(pelf.cost_allocation_keyflex_id,'ELEMENT') value, null description from per_business_groups pbg, pay_element_links_f pelf where pbg.name=:$column$.business_group and pelf.business_group_id=pbg.business_group_id and pelf.cost_allocation_keyflex_id is not null order by value Costing segments of the Cost Allocation flexfield that the form shows for links (segments enabled at Element level), separated by the flexfield delimiter. A new combination is created when it does not exist. 31 BALANCING LOV custom varchar2 2000 Y select distinct xxen_hr_upload.cost_keyflex_dsp(pelf.balancing_keyflex_id,'BALANCING') value, null description from per_business_groups pbg, pay_element_links_f pelf where pbg.name=:$column$.business_group and pelf.business_group_id=pbg.business_group_id and pelf.balancing_keyflex_id is not null order by value Balancing segments of the Cost Allocation flexfield, separated by the flexfield delimiter. Required for a costed link. 32 QUALIFYING_AGE Number number select petfv.qualifying_age from per_business_groups pbg, pay_element_types_f_vl petfv where pbg.name=:$column$.business_group and (petfv.business_group_id=pbg.business_group_id or petfv.business_group_id is null and petfv.legislation_code=pbg.legislation_code) and petfv.element_name=:$column$.element_name and nvl(:$column$.effective_date,trunc(sysdate)) between petfv.effective_start_date and petfv.effective_end_date 33 QUALIFYING_LENGTH_OF_SERVICE Number number select petfv.qualifying_length_of_service from per_business_groups pbg, pay_element_types_f_vl petfv where pbg.name=:$column$.business_group and (petfv.business_group_id=pbg.business_group_id or petfv.business_group_id is null and petfv.legislation_code=pbg.legislation_code) and petfv.element_name=:$column$.element_name and nvl(:$column$.effective_date,trunc(sysdate)) between petfv.effective_start_date and petfv.effective_end_date 34 QUALIFYING_UNITS 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='QUALIFYING_UNITS' 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 select xxen_util.meaning(petfv.qualifying_units,'QUALIFYING_UNITS',3) from per_business_groups pbg, pay_element_types_f_vl petfv where pbg.name=:$column$.business_group and (petfv.business_group_id=pbg.business_group_id or petfv.business_group_id is null and petfv.legislation_code=pbg.legislation_code) and petfv.element_name=:$column$.element_name and nvl(:$column$.effective_date,trunc(sysdate)) between petfv.effective_start_date and petfv.effective_end_date 35 LINK_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=801 and fdfcv.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 36 LINK_ATTRIBUTE1 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE1' 37 LINK_ATTRIBUTE2 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE2' 38 LINK_ATTRIBUTE3 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE3' 39 LINK_ATTRIBUTE4 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE4' 40 LINK_ATTRIBUTE5 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE5' 41 LINK_ATTRIBUTE6 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE6' 42 LINK_ATTRIBUTE7 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE7' 43 LINK_ATTRIBUTE8 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE8' 44 LINK_ATTRIBUTE9 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE9' 45 LINK_ATTRIBUTE10 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE10' 46 LINK_ATTRIBUTE11 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE11' 47 LINK_ATTRIBUTE12 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE12' 48 LINK_ATTRIBUTE13 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE13' 49 LINK_ATTRIBUTE14 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE14' 50 LINK_ATTRIBUTE15 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE15' 51 LINK_ATTRIBUTE16 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE16', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE16' 52 LINK_ATTRIBUTE17 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE17', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE17' 53 LINK_ATTRIBUTE18 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE18', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE18' 54 LINK_ATTRIBUTE19 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE19', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE19' 55 LINK_ATTRIBUTE20 LOV custom varchar2 150 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=>801, p_descriptive_flexfield_name=>'PAY_ELEMENT_LINKS', p_context_name=>:$column$.link_attribute_category, p_column_name=>'ATTRIBUTE20', p_attribute1=>:$column$.link_attribute1, p_attribute2=>:$column$.link_attribute2, p_attribute3=>:$column$.link_attribute3, p_attribute4=>:$column$.link_attribute4, p_attribute5=>:$column$.link_attribute5, p_attribute6=>:$column$.link_attribute6, p_attribute7=>:$column$.link_attribute7, p_attribute8=>:$column$.link_attribute8, p_attribute9=>:$column$.link_attribute9, p_attribute10=>:$column$.link_attribute10, p_attribute11=>:$column$.link_attribute11, p_attribute12=>:$column$.link_attribute12, p_attribute13=>:$column$.link_attribute13, p_attribute14=>:$column$.link_attribute14, p_attribute15=>:$column$.link_attribute15, p_attribute16=>:$column$.link_attribute16, p_attribute17=>:$column$.link_attribute17, p_attribute18=>:$column$.link_attribute18, p_attribute19=>:$column$.link_attribute19, p_attribute20=>:$column$.link_attribute20)) 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=801 and fdfc.descriptive_flexfield_name='PAY_ELEMENT_LINKS' and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE20' 56 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 p_element_link_id_out in/out Number ELEMENT_LINK_ID_OUT U 3 p_business_group_id in Number BUSINESS_GROUP U 4 p_element_type_id in Number ELEMENT_NAME U 5 p_element_link_id in Number Y ELEMENT_LINK_ID U 6 p_standard_link in Char Y STANDARD U 7 p_effective_date in Date Y EFFECTIVE_DATE U 8 p_datetrack_mode in Char Y DATETRACK_MODE U 9 p_end_date in Date Y END_DATE U 10 p_organization_id in Number Y ORGANIZATION U 11 p_job_id in Number Y JOB U 12 p_position_id in Number Y POSITION U 13 p_grade_id in Number Y GRADE U 14 p_people_group in Char Y PEOPLE_GROUP U 15 p_location_id in Number Y LOCATION U 16 p_pay_basis_id in Number Y SALARY_BASIS U 17 p_employment_category in Char Y EMPLOYMENT_CATEGORY U 18 p_payroll_id in Number Y PAYROLL U 19 p_link_to_all_payrolls in Char Y LINK_TO_ALL_PAYROLLS U 20 p_costable_type in Char Y COSTABLE_TYPE U 21 p_transfer_to_gl in Char Y TRANSFER_TO_GL U 22 p_element_set_id in Number Y DISTRIBUTION_SET U 23 p_costing in Char Y COSTING U 24 p_balancing in Char Y BALANCING U 25 p_qualifying_age in Number Y QUALIFYING_AGE U 26 p_qualifying_length_of_service in Number Y QUALIFYING_LENGTH_OF_SERVICE U 27 p_qualifying_units in Char Y QUALIFYING_UNITS U 28 p_link_attribute_category in Char Y LINK_ATTRIBUTE_CATEGORY U 29 p_link_attribute1 in Char Y LINK_ATTRIBUTE1 U 30 p_link_attribute2 in Char Y LINK_ATTRIBUTE2 U 31 p_link_attribute3 in Char Y LINK_ATTRIBUTE3 U 32 p_link_attribute4 in Char Y LINK_ATTRIBUTE4 U 33 p_link_attribute5 in Char Y LINK_ATTRIBUTE5 U 34 p_link_attribute6 in Char Y LINK_ATTRIBUTE6 U 35 p_link_attribute7 in Char Y LINK_ATTRIBUTE7 U 36 p_link_attribute8 in Char Y LINK_ATTRIBUTE8 U 37 p_link_attribute9 in Char Y LINK_ATTRIBUTE9 U 38 p_link_attribute10 in Char Y LINK_ATTRIBUTE10 U 39 p_link_attribute11 in Char Y LINK_ATTRIBUTE11 U 40 p_link_attribute12 in Char Y LINK_ATTRIBUTE12 U 41 p_link_attribute13 in Char Y LINK_ATTRIBUTE13 U 42 p_link_attribute14 in Char Y LINK_ATTRIBUTE14 U 43 p_link_attribute15 in Char Y LINK_ATTRIBUTE15 U 44 p_link_attribute16 in Char Y LINK_ATTRIBUTE16 U 45 p_link_attribute17 in Char Y LINK_ATTRIBUTE17 U 46 p_link_attribute18 in Char Y LINK_ATTRIBUTE18 U 47 p_link_attribute19 in Char Y LINK_ATTRIBUTE19 U 48 p_link_attribute20 in Char Y LINK_ATTRIBUTE20 U 49 status_ out Char STATUS_CODE_ U 50 message_ out Char MESSAGE_ Error SQL Order By upload_row, business_group, element_name, start_date Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.element_link_id_out, pelf.element_link_id, pbg.name business_group, (select petfv.element_name from pay_element_types_f_vl petfv where pelf.element_type_id=petfv.element_type_id and xu.row_date between petfv.effective_start_date and petfv.effective_end_date) element_name, (select petfv.description from pay_element_types_f_vl petfv where pelf.element_type_id=petfv.element_type_id and xu.row_date between petfv.effective_start_date and petfv.effective_end_date) element_description, (select pecv.classification_name from pay_element_types_f petf, pay_element_classifications_vl pecv where pelf.element_type_id=petf.element_type_id and xu.row_date between petf.effective_start_date and petf.effective_end_date and petf.classification_id=pecv.classification_id) classification, (select xxen_util.meaning(petf.processing_type,'PROCESSING_TYPE',3) from pay_element_types_f petf where pelf.element_type_id=petf.element_type_id and xu.row_date between petf.effective_start_date and petf.effective_end_date) processing_type, xxen_util.yes(pelf.standard_link_flag) standard, xu.effective_date, xu.datetrack_mode, (select min(pelf2.effective_start_date) from pay_element_links_f pelf2 where pelf.element_link_id=pelf2.element_link_id) start_date, (select nullif(max(pelf2.effective_end_date),to_date('31-12-4712','DD-MM-YYYY')) from pay_element_links_f pelf2 where xu.element_link_id_out=pelf2.element_link_id) end_date, (select haouv.name from hr_all_organization_units_vl haouv where pelf.organization_id=haouv.organization_id) organization, (select pjv.name from per_jobs_vl pjv where pelf.job_id=pjv.job_id) job, (select hpf.name from hr_positions_f hpf where pelf.position_id=hpf.position_id and xu.row_date between hpf.effective_start_date and hpf.effective_end_date) position, (select pgv.name from per_grades_vl pgv where pelf.grade_id=pgv.grade_id) grade, (select ppg.group_name from pay_people_groups ppg where pelf.people_group_id=ppg.people_group_id) people_group, (select hlav.location_code from hr_locations_all_vl hlav where pelf.location_id=hlav.location_id) location, (select ppb.name from per_pay_bases ppb where pelf.pay_basis_id=ppb.pay_basis_id) salary_basis, xxen_util.meaning(pelf.employment_category,'EMP_CAT',3) employment_category, (select papf.payroll_name from pay_all_payrolls_f papf where pelf.payroll_id=papf.payroll_id and xu.row_date between papf.effective_start_date and papf.effective_end_date) payroll, xxen_util.yes(pelf.link_to_all_payrolls_flag) link_to_all_payrolls, xxen_util.meaning(pelf.costable_type,'COSTABLE_TYPE',3) costable_type, xxen_util.yes(pelf.transfer_to_gl_flag) transfer_to_gl, (select pes.element_set_name from pay_element_sets pes where pelf.element_set_id=pes.element_set_id) distribution_set, xxen_hr_upload.cost_keyflex_dsp(pelf.cost_allocation_keyflex_id,'ELEMENT') costing, xxen_hr_upload.cost_keyflex_dsp(pelf.balancing_keyflex_id,'BALANCING') balancing, pelf.qualifying_age, pelf.qualifying_length_of_service, xxen_util.meaning(pelf.qualifying_units,'QUALIFYING_UNITS',3) qualifying_units, xxen_util.display_flexfield_context(801,'PAY_ELEMENT_LINKS',pelf.attribute_category) link_attribute_category, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE1',pelf.rowid,pelf.attribute1) link_attribute1, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE2',pelf.rowid,pelf.attribute2) link_attribute2, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE3',pelf.rowid,pelf.attribute3) link_attribute3, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE4',pelf.rowid,pelf.attribute4) link_attribute4, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE5',pelf.rowid,pelf.attribute5) link_attribute5, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE6',pelf.rowid,pelf.attribute6) link_attribute6, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE7',pelf.rowid,pelf.attribute7) link_attribute7, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE8',pelf.rowid,pelf.attribute8) link_attribute8, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE9',pelf.rowid,pelf.attribute9) link_attribute9, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE10',pelf.rowid,pelf.attribute10) link_attribute10, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE11',pelf.rowid,pelf.attribute11) link_attribute11, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE12',pelf.rowid,pelf.attribute12) link_attribute12, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE13',pelf.rowid,pelf.attribute13) link_attribute13, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE14',pelf.rowid,pelf.attribute14) link_attribute14, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE15',pelf.rowid,pelf.attribute15) link_attribute15, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE16',pelf.rowid,pelf.attribute16) link_attribute16, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE17',pelf.rowid,pelf.attribute17) link_attribute17, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE18',pelf.rowid,pelf.attribute18) link_attribute18, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE19',pelf.rowid,pelf.attribute19) link_attribute19, xxen_util.display_flexfield_value(801,'PAY_ELEMENT_LINKS',pelf.attribute_category,'ATTRIBUTE20',pelf.rowid,pelf.attribute20) link_attribute20, xu.upload_row from ( select xu.*, case when xu.end_date<nvl(xu.effective_date,trunc(sysdate)) then xu.end_date else nvl(xu.effective_date,trunc(sysdate)) end row_date from xxen_per_payroll_elemen_9319_u xu where xu.status_code_=xxen_upload.status_success ) xu, pay_element_links_f pelf, per_business_groups pbg where xu.element_link_id_out=pelf.element_link_id(+) and xu.row_date between pelf.effective_start_date(+) and pelf.effective_end_date(+) and pelf.business_group_id=pbg.business_group_id(+)