ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4717251A9E05362FB09050512Y select pai.action_information2 EMP_EMAIL, pai.action_information3 HOME_PHONE, pai.action_information4 BUS_PHONE, pai.action_information5 FAX_NUMBER, pai.action_information6 CELL_NUMBER, pai.action_information7 BUS_UNIT_NUMBER, pai.action_information8 BUS_COMPLEX, pai.action_information9 BUS_STREET_NUM, pai.action_information10 BUS_FORM, pai.action_information11 BUS_SUBURB, pai.action_information12 BUS_CITY, trim(substr(pai.action_information13,1,10)) BUS_POSTAL_CODE, trim(substr(pai.action_information13,11)) BUS_COUNTRY_CODE, pai.action_information14 RES_UNIT_NUMBER, pai.action_information15 RES_COMPLEX, pai.action_information16 RES_STREET_NUM, pai.action_information17 RES_FORM, pai.action_information18 RES_SUBURB, pai.action_information19 RES_CITY, trim(substr(pai.action_information20,1,10)) RES_POSTAL_CODE, trim(substr(pai.action_information20,11)) RES_COUNTRY_CODE, decode(substr(pai.action_information21,1,1),'X','X',null) POS_RES_ADD_SAME, decode(nvl(substr(pai.action_information21,1,1),'X'),'X',null,'2','Y','N') POS_STR_ADD, decode(substr(pai.action_information21,1,1),'3','X',null) POS_POB_ADD, decode(substr(pai.action_information21,1,1),'4','X',null) POS_PB_ADD, decode(substr(pai.action_information21,2,1),'Y','Y','N') POS_CO_ADD, substr(pai.action_information21,3) POS_CARE_INTER_ADD, decode(nvl(substr(pai.action_information21,1,1),'1'),'1',pai.action_information22,null) POS_LINE1, decode(nvl(substr(pai.action_information21,1,1),'1'),'1',pai.action_information23,null) POS_LINE2, decode(nvl(substr(pai.action_information21,1,1),'1'),'1',trim(substr(pai.action_information24,1,35)),null) POS_LINE3, decode(nvl(substr(pai.action_information21,1,1),'1'),'1',trim(substr(pai.action_information24,36)),null) POS_LINE4, decode(nvl(substr(pai.action_information21,1,1),'1'),'1',trim(substr(pai.action_information25,1,10)),null) POS_CODE, decode(nvl(substr(pai.action_information21,1,1),'1'),'1',trim(substr(pai.action_information25,11)),null) POS_COUN_CODE, decode(substr(pai.action_information21,1,1),'2',trim(substr(pai.action_information22,14,8)), null) PSA_UN, decode(substr(pai.action_information21,1,1),'2',trim(substr(pai.action_information22,33,26)), null) PSA_CO, decode(substr(pai.action_information21,1,1),'2',trim(substr(pai.action_information23,16,8)), null) PSA_SN, decode(substr(pai.action_information21,1,1),'2',trim(substr(pai.action_information23,50,26)), null) PSA_SNF, decode(substr(pai.action_information21,1,1),'2',trim(substr(pai.action_information24,21,33)), null) PSA_SD, decode(substr(pai.action_information21,1,1),'2',trim(substr(pai.action_information24,70,21)), null) PSA_CT, decode(substr(pai.action_information21,1,1),'2',substr(pai.action_information25,1,10),null) PSA_PC, decode(substr(pai.action_information21,1,1),'2',substr(pai.action_information25,11),null) PSA_CC, decode(substr(pai.action_information21,1,1),'X','1','1','4','2','3','2') P_3288, decode(substr(pai.action_information21,1,1),'3','PO_BOX','4','PRIVATE_BAG',null) P_3249, decode(substr(pai.action_information21,1,1),'5',trim(substr(pai.action_information22,27,21)), null) P_3280, decode(substr(pai.action_information21,1,1),'3',trim(substr(pai.action_information22,28,length(pai.action_information22))),'4',trim(substr(pai.action_information22,28,length(pai.action_information22))),'5',trim(substr(pai.action_information22,77,21)), null) P_3251, decode(substr(pai.action_information21,1,1),'3',trim(substr(pai.action_information23,16,length(pai.action_information23))),'4',trim(substr(pai.action_information23,21,length(pai.action_information23))),'5',trim(substr(pai.action_information23,25,length(pai.action_information23))),null) P_3262, decode(substr(pai.action_information21,1,1),'3',trim(substr(pai.action_information24,26,length(pai.action_information24))),'4',trim(substr(pai.action_information24,26,length(pai.action_information24))),'5',trim(substr(pai.action_information24,26,length(pai.action_information24))),null) P_3253, decode(substr(pai.action_information21,1,1),'3',trim(substr(pai.action_information25,1,10)),'4',trim(substr(pai.action_information25,1,10)),'5',trim(substr(pai.action_information25,1,10)),null) P_3254, decode(substr(pai.action_information21,1,1),'3',substr(pai.action_information25,11),'4',substr(pai.action_information25,11),'5',substr(pai.action_information25,11),null) P_3286 from pay_action_information pai, pay_assignment_actions paa where pai.action_context_id = paa.assignment_action_id and pai.action_context_type = 'AAP' and pai.action_information_category = 'ZATYE_EMPLOYEE_CONTACT_INFO' and pai.action_information30 = :TEMP_CERTIFICATE_NUMBER &C_PAYROLL_ACTION_ID PAY PYZAIT3A_XML US PAY IT3A Tax Certificates Imported from BI Publisher Description: IRP5 Certificates Process Application: Payroll Source: IT3A Tax Certificates Short Name: PYZAIT3A_XML DB package: PAY_ZA_IRP5_IT3A_XMLP_PKG BI Publisher &c_payroll_action_id :c_action_context_id :c_assignment_no :c_certificate_type :c_payroll_action_id :c_sort_order :p_assignment_no :p_business_group_id :p_cert_no :p_certificate_type :p_dummy_run :p_legal_entity :p_payroll :p_payroll_action_id :p_period_recon :p_reissue_irp5 :p_sort_order1 :p_sort_order2 :p_sort_order3 :p_sort_order4 :p_sort_order5 :p_tax_year :temp_certificate_number 1 -30 :p_certificate_type Char IT3(a) US PY_ZA_CHAR_10 Certificate Type 2 -10 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') US Business Group ID Business Group ID 3 10 :p_legal_entity LOV Oracle PER_ZA_LEGAL_ENTITY Y select haou.organization_id id, haou.name value, null description from fnd_sessions fss,hr_all_organization_units haou,hr_organization_information hoi,hr_organization_information hoi2 where fss.session_id=userenv('sessionid') and fss.effective_date between haou.date_from and nvl(haou.date_to,to_date('31-12-4712','DD-MM-YYYY')) and haou.business_group_id=fnd_global.per_business_group_id and hoi.organization_id=haou.organization_id and hoi.org_information_context='ZA_LEGAL_ENTITY' and hoi2.organization_id=haou.organization_id and hoi2.org_information_context='CLASS' and hoi2.org_information1='HR_LEGAL' and hoi2.org_information2='Y' order by haou.name Y US Legal Entity Legal Entity 4 20 :p_tax_year Number Y US PAY_ZA_TAX_YEAR Tax Year 5 30 :p_period_recon LOV Oracle PAY_ZA_PERIOD_OF_RECON Y select hl.lookup_code id, hl.meaning value, null description from hr_lookups hl where lookup_type='PAY_ZA_PERIOD_OF_RECON' and enabled_flag='Y' order by value,description Y US Period of Reconciliation Period of Reconciliation 6 40 :p_payroll LOV Oracle PY_SRS_PAYROLL Y select pay.payroll_id id, pay.payroll_name value, null description from pay_payrolls_f pay,fnd_sessions fnd where pay.business_group_id= fnd_global.per_business_group_id and fnd.session_id=userenv('sessionid') and fnd.effective_date between pay.effective_start_date and pay.effective_end_date order by pay.payroll_name US Payroll Payroll 7 50 :p_payroll_action_id LOV Oracle PY_ZA_NEW_IRP5_PREPROCESS Y select ppa.payroll_action_id id, to_char(ppa.effective_date,'DD-MON-YYYY') || '(' || to_char(ppa.payroll_action_id)||')' value, null description from pay_payroll_actions ppa,pay_payrolls_f ppf,per_people_f per,hr_assignment_sets has where ppa.business_group_id+0=fnd_global.per_business_group_id and ppa.action_type='X' and ppa.report_type='ZA_TYE' and ppa.action_status='C' and pay_za_irp5_archive_pkg.get_parameter('TAX_YEAR',ppa.legislative_parameters)=:$flex$.pay_za_tax_year and nvl(pay_za_irp5_archive_pkg.get_parameter('PERIOD_RECON',ppa.legislative_parameters),'02')=:$flex$.pay_za_period_of_recon and nvl(pay_za_irp5_archive_pkg.get_parameter('PAYROLL_ID',ppa.legislative_parameters),0)=nvl(:$flex$.py_srs_payroll:null,nvl(pay_za_irp5_archive_pkg.get_parameter('PAYROLL_ID',ppa.legislative_parameters),0)) and pay_za_irp5_archive_pkg.get_parameter('LEGAL_ENTITY',ppa.legislative_parameters)=:$flex$.per_za_legal_entity and pay_za_irp5_archive_pkg.get_parameter('CERT_TYPE',ppa.legislative_parameters)=1 and pay_za_irp5_archive_pkg.get_parameter('PAYROLL_ID',ppa.legislative_parameters)=ppf.payroll_id(+) and ppa.effective_date between ppf.effective_start_date(+) and ppf.effective_end_date(+) and pay_za_irp5_archive_pkg.get_parameter('PERSON_ID',ppa.legislative_parameters)=per.person_id (+) and ppa.effective_date between per.effective_start_date (+) and per.effective_end_date (+) and pay_za_irp5_archive_pkg.get_parameter('ASG_SET_ID',ppa.legislative_parameters)=has.assignment_set_id (+) order by ppa.request_id desc Y US Tax Certificate Preprocess Tax Certificate Preprocess 8 60 :p_assignment_no LOV Oracle PY_SRS_ZA_NEW_IRP5_EMPLOYEE Y select paf.assignment_id id, paf.assignment_number value, null description from per_people_f ppf,per_assignments_f paf,pay_assignment_actions paa,pay_payroll_actions ppa,pay_action_information pai where ppa.payroll_action_id=:$flex$.py_za_new_irp5_preprocess and paa.payroll_action_id=ppa.payroll_action_id and pai.action_context_id=paa.assignment_action_id and pai.action_context_type='AAP' and pai.action_information_category='ZATYE_EMPLOYEE_INFO' and pai.action_information2=:$flex$.py_za_char_10 and pai.action_information30= (select max(pai1.action_information30) from pay_action_information pai1 where pai1.action_context_id=paa.assignment_action_id and pai1.action_information2=:$flex$.py_za_char_10 ) and paa.action_sequence= ( select max(paa2.action_sequence) from pay_assignment_actions paa2 where paa2.payroll_action_id=ppa.payroll_action_id and paa2.assignment_id=paa.assignment_id ) and paf.assignment_id=paa.assignment_id and paf.effective_start_date= ( select max(paf2.effective_start_date) from per_assignments_f paf2 where paf2.effective_start_date<=ppa.effective_date and paf2.assignment_id=paa.assignment_id ) and ppf.person_id=paf.person_id and ppf.effective_start_date= ( select max(ppf2.effective_start_date) from per_people_f ppf2 where ppf2.effective_start_date<=ppa.effective_date and ppf2.person_id=paf.person_id ) order by value,description US Assignment Number Assignment Number 9 70 :p_dummy_run LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y US Dummy Run Dummy Run 10 80 :p_reissue_irp5 LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y US Reissue IT3A Tax Certificate Reissue IT3(a) Tax Certificate 11 90 :p_sort_order1 LOV Oracle PY_SRS_ZA_NEW_TAXCERT_SORT Y select lo.lookup_code id, lo.meaning value, null description from hr_lookups lo,fnd_sessions fnd where lo.lookup_type='ZA_NEW_IRP5_SORT_ORDER' and fnd.session_id=userenv('sessionid') and lo.enabled_flag='Y' and fnd.effective_date between nvl(start_date_active,fnd.effective_date) and nvl(end_date_active,fnd.effective_date) order by lo.meaning select meaning from hr_lookups where lookup_type = 'ZA_NEW_IRP5_SORT_ORDER' and lookup_code = '1' US Sort Order 1 Sort Order 1 12 100 :p_sort_order2 LOV Oracle PY_SRS_ZA_NEW_TAXCERT_SORT Y select lo.lookup_code id, lo.meaning value, null description from hr_lookups lo,fnd_sessions fnd where lo.lookup_type='ZA_NEW_IRP5_SORT_ORDER' and fnd.session_id=userenv('sessionid') and lo.enabled_flag='Y' and fnd.effective_date between nvl(start_date_active,fnd.effective_date) and nvl(end_date_active,fnd.effective_date) order by lo.meaning select meaning from hr_lookups where lookup_type = 'ZA_NEW_IRP5_SORT_ORDER' and lookup_code = '2' US Sort Order 2 Sort Order 2 13 110 :p_sort_order3 LOV Oracle PY_SRS_ZA_NEW_TAXCERT_SORT Y select lo.lookup_code id, lo.meaning value, null description from hr_lookups lo,fnd_sessions fnd where lo.lookup_type='ZA_NEW_IRP5_SORT_ORDER' and fnd.session_id=userenv('sessionid') and lo.enabled_flag='Y' and fnd.effective_date between nvl(start_date_active,fnd.effective_date) and nvl(end_date_active,fnd.effective_date) order by lo.meaning select meaning from hr_lookups where lookup_type = 'ZA_NEW_IRP5_SORT_ORDER' and lookup_code = '3' US Sort Order 3 Sort Order 3 14 120 :p_sort_order4 LOV Oracle PY_SRS_ZA_NEW_TAXCERT_SORT Y select lo.lookup_code id, lo.meaning value, null description from hr_lookups lo,fnd_sessions fnd where lo.lookup_type='ZA_NEW_IRP5_SORT_ORDER' and fnd.session_id=userenv('sessionid') and lo.enabled_flag='Y' and fnd.effective_date between nvl(start_date_active,fnd.effective_date) and nvl(end_date_active,fnd.effective_date) order by lo.meaning select meaning from hr_lookups where lookup_type = 'ZA_NEW_IRP5_SORT_ORDER' and lookup_code = '4' US Sort Order 4 Sort Order 4 15 130 :p_sort_order5 LOV Oracle PY_SRS_ZA_NEW_TAXCERT_SORT Y select lo.lookup_code id, lo.meaning value, null description from hr_lookups lo,fnd_sessions fnd where lo.lookup_type='ZA_NEW_IRP5_SORT_ORDER' and fnd.session_id=userenv('sessionid') and lo.enabled_flag='Y' and fnd.effective_date between nvl(start_date_active,fnd.effective_date) and nvl(end_date_active,fnd.effective_date) order by lo.meaning select meaning from hr_lookups where lookup_type = 'ZA_NEW_IRP5_SORT_ORDER' and lookup_code = '5' US Sort Order 5 Sort Order 5