ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4714B51A9E05362FB09050512Y select distinct ppei2.information_type, hslv.org_information4 RCB_NO, hou.name STOCK_OPTION_COMPANY_NAME, fnd_date.canonical_to_date(ppei1.pei_information3) DATE_OF_GRANT, fnd_date.canonical_to_date(ppei2.pei_information5) DATE_OF_EXERCISE, ppei2.pei_information3 EXERCISE_PRICE, ppei1.pei_information2 MARKET_VALUE_GRANT, ppei2.pei_information4 MARKET_VALUE_EXERCISE, ppei2.pei_information6 NO_OF_SHARES_ACQ, DECODE(ppei2.pei_information1, 'E',1,'EE',2,'C',3,null) STOCK_OPTION, ppf.per_information1 employee_name, ppf.national_identifier identification_no, hoi1.org_information5 contact_name, hoi1.org_information6 contact_number, hoi2.org_information8 auth_per_name_new, hoi2.org_information9 auth_per_desig_new, PAY_PAYSG21A_XMLP_PKG.cf_gross_amt_not_tax_exemptfor(DECODE ( ppei2.pei_information1 , 'E' , 1 , 'EE' , 2 , 'C' , 3 , null ), ppei2.pei_information4, ppei2.pei_information3, ppei2.pei_information6, ppei1.pei_information2) CF_1, PAY_PAYSG21A_XMLP_PKG.CP_1_p CP_1, PAY_PAYSG21A_XMLP_PKG.CP_2_p CP_2, PAY_PAYSG21A_XMLP_PKG.CP_3_p CP_3, PAY_PAYSG21A_XMLP_PKG.CP_4_p CP_4, PAY_PAYSG21A_XMLP_PKG.CP_5_p CP_5, PAY_PAYSG21A_XMLP_PKG.CP_6_p CP_6, PAY_PAYSG21A_XMLP_PKG.CP_7_p CP_7 from per_people_extra_info ppei1, per_people_extra_info ppei2, hr_organization_units hou, hr_soft_coding_keyflex hsc, hr_organization_information hoi1, hr_organization_information hoi2, per_people_f ppf, per_assignments_f paf, hr_sg_leg_ent_v hslv, hr_lookups hl where to_char(ppei1.person_extra_info_id) = ppei2.pei_information2 and hslv.org_information15=hl.lookup_code and hou.organization_id = ppei1.pei_information1 and hl.lookup_type = 'SG_ER_PAYER_ID' and ppei2.information_type = 'HR_STOCK_EXERCISE_SG' and ppei1.information_type = 'HR_STOCK_GRANT_SG' and ppei2.person_id = ppei1.person_id and ppei1.person_id = ppf.person_id and ppf.person_id = paf.person_id and ppf.person_id = :p_person_id and paf.effective_start_date = (select max(paf1.effective_start_date) from per_assignments_f paf1 where paf1.person_id = paf.person_id and paf1.assignment_id = paf.assignment_id and paf1.assignment_type = 'E' and paf1.effective_start_date <= to_date('31/12/'||:p_basis_year,'DD/MM/YYYY') and paf1.effective_end_date >= to_date('01/01/'||:p_basis_year,'DD/MM/YYYY') and paf1.primary_flag = 'Y') and paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id and hsc.segment1=hoi1.organization_id and hslv.organization_id = hou.organization_id and hoi1.organization_id = hoi2.organization_id and hoi1.org_information_context = 'SG_LEGAL_ENTITY' and hoi2.org_information_context = 'SG_LE_IRAS' and hl.meaning = 'ROC' and hl.application_id = 800 and to_char(to_date(ppei2.pei_information5,'YYYY/MM/DD HH24:MI:SS'),'YYYY') = :p_basis_year order by STOCK_OPTION PAY PAYSG21A_XML US PAY Inland Revenue Form IR21 (Singapore) Imported from BI Publisher Description: Inland Revenue Form IR21 (Singapore) Application: Payroll Source: Inland Revenue Form IR21 (Singapore) (XML) Short Name: PAYSG21A_XML DB package: PAY_PAYSG21A_XMLP_PKG BI Publisher :cp_1 :cp_2 :cp_3 :cp_4 :cp_5 :cp_6 :cp_7 :p_basis_year :p_business_group_id :p_conc_request_id :p_cr_year_amount :p_ir21_mode :p_person_id :p_pr_year_amount :p_run 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') US Business Group Id 2 10 :p_basis_year LOV Oracle PY_SG_BASIS_YEAR Y select year_name id, year_name value, null description from pay_srs_year_periods_v where business_group_id=fnd_global.per_business_group_id and to_number(year_name) between (to_number(to_char(sysdate,'YYYY'))-3) and (to_number(to_char(sysdate,'YYYY'))) order by year_name select to_char(sysdate,'YYYY') from dual Y US Basis_Year 3 20 :p_person_id LOV Oracle PY_SG_TERMINATED_EMPLOYEES Y select papf.person_id id, papf.per_information1 value, null description from per_people_f papf,per_periods_of_service pps where papf.business_group_id=fnd_global.per_business_group_id and papf.person_id=pps.person_id and pps.actual_termination_date between papf.effective_start_date and papf.effective_end_date and (pps.final_process_date between to_date('01-JAN-' || to_char(:$flex$.basis_year),'DD-MON-YYYY') and to_date('31-DEC-' || to_char(:$flex$.basis_year),'DD-MON-YYYY') or pps.actual_termination_date between to_date('01-JAN-' || to_char(:$flex$.basis_year),'DD-MON-YYYY') and to_date('31-DEC-' || to_char(:$flex$.basis_year),'DD-MON-YYYY')) and papf.effective_start_date=(select max(papf1.effective_start_date) from per_people_f papf1,per_periods_of_service pps1 where papf1.person_id=papf.person_id and papf1.person_id=pps1.person_id and pps1.actual_termination_date between papf1.effective_start_date and papf1.effective_end_date and (pps1.final_process_date between to_date('01-JAN-' || to_char(:$flex$.basis_year),'DD-MON-YYYY') and to_date('31-DEC-' || to_char(:$flex$.basis_year),'DD-MON-YYYY') or pps1.actual_termination_date between to_date('01-JAN-' || to_char(:$flex$.basis_year),'DD-MON-YYYY') and to_date('31-DEC-' || to_char(:$flex$.basis_year),'DD-MON-YYYY'))) order by papf.per_information1 Y US Employee Name 4 30 :p_ir21_mode LOV Oracle PY_SG_IR21_MODE Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='SG_IR21_MODE' and application_id=800 and enabled_flag='Y' order by meaning select decode(max(NVL(ppeo.pei_information1,'01-Jan-1900')),'01-Jan-1900','Original','Amended') from per_all_people_f papf, per_periods_of_service pps, per_people_extra_info ppeo where papf.business_group_id = fnd_global.PER_BUSINESS_GROUP_ID and papf.person_id = :$flex$.employee_name and papf.person_id = pps.person_id and pps.actual_termination_date between papf.effective_start_date and papf.effective_end_date and pps.actual_termination_date between to_date('01-JAN-' || to_char(:$FLEX$.Basis_Year),'DD-MON-YYYY') and to_date('31-DEC-' || to_char(:$FLEX$.Basis_Year),'DD-MON-YYYY') and papf.person_id = ppeo.person_id (+) and ppeo.information_type (+) = 'HR_IR21_PROCESSING_DATES_SG' Y US Report Mode