ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3503869E053B46B63588994Y select distinct pac.assignment_action_id ,pac.assignment_id ,ppa.payroll_action_id ,pay_sg_iras_archive.get_archive_value('X_SG_LEGAL_ENTITY_SG_LEGAL_ENTITY_NAME', pac.assignment_action_id) X_LEGAL_ENTITY_NAME ,pay_sg_iras_archive.get_archive_value('X_SG_LEGAL_ENTITY_SG_ER_INCOME_TAX_NUMBER',pac.assignment_action_id) X_ER_TAX_NUMBER ,pay_sg_iras_archive.get_archive_value('X_PEOPLE_FLEXFIELD_SG_SG_LEGAL_NAME', pac.assignment_action_id) X_EE_LEGAL_NAME ,pay_sg_iras_archive.get_archive_value('X_PER_NATIONAL_IDENTIFIER', pac.assignment_action_id) X_EE_NRIC ,pay_sg_iras_archive.get_archive_value('X_PEOPLE_FLEXFIELD_SG_SG_INCOME_TAX_NUMBER', pac.assignment_action_id) X_EE_TAX_NUMBER ,to_number(pay_sg_iras_archive.get_archive_value('X_IR8S_MOA_408_PER_LE_YTD', pac.assignment_action_id)) X_IR8S_MOA_408_PER_LE_YTD ,to_number(pay_sg_iras_archive.get_archive_value('X_IR8S_MOA_409_PER_LE_YTD', pac.assignment_action_id)) X_IR8S_MOA_409_PER_LE_YTD ,decode(pay_sg_iras_archive.get_archive_value('X_HR_IR8S_INDICATORS_SG_ASG_CPF_OVERSEAS_POST_OBLIGATORY', pac.assignment_action_id),'Y','X',Null) X_IR8S_CPF_OBLI_YES ,decode(pay_sg_iras_archive.get_archive_value('X_HR_IR8S_INDICATORS_SG_ASG_CPF_OVERSEAS_POST_OBLIGATORY', pac.assignment_action_id),'N','X',' ','X',Null) X_IR8S_CPF_OBLI_NO ,to_char(fnd_date.canonical_to_date(pay_sg_iras_archive.get_archive_value('X_ASG_OVERSEAS_DATE_FROM', pac.assignment_action_id)),'DD-MON-YYYY') X_ASG_OVS_DATE_FROM ,to_char(fnd_date.canonical_to_date(pay_sg_iras_archive.get_archive_value('X_ASG_OVERSEAS_DATE_TO', pac.assignment_action_id)),'DD-MON-YYYY') X_ASG_OVS_DATE_TO from pay_assignment_actions pac, pay_payroll_actions ppa, per_all_assignments_f paa where ppa.payroll_action_id = pac.payroll_action_id and pac.assignment_id = paa.assignment_id and ppa.report_type ='SG_IR8S_ADHOC_REPORT' and ppa.action_type = 'X' and ppa.action_status ='C' and ppa.payroll_action_id = :P_PAYROLL_ACTION_ID /*order by decode(pay_sg_iras_archive.get_archive_value('X_HR_IR8S_INDICATORS_SG_ASG_CPF_OVERSEAS_POST_OBLIGATORY', pac.assignment_action_id),'Y','X',Null), decode(pay_sg_iras_archive.get_archive_value('X_HR_IR8S_INDICATORS_SG_ASG_CPF_OVERSEAS_POST_OBLIGATORY', pac.assignment_action_id),'N','X',' ','X',Null), to_char(fnd_date.canonical_to_date(pay_sg_iras_archive.get_archive_value('X_ASG_OVERSEAS_DATE_FROM', pac.assignment_action_id)),'DD-MON-YYYY'), to_char(fnd_date.canonical_to_date(pay_sg_iras_archive.get_archive_value('X_ASG_OVERSEAS_DATE_TO', pac.assignment_action_id)),'DD-MON-YYYY'), pac.assignment_id, ppa.payroll_action_id, pay_sg_iras_archive.get_archive_value('X_SG_LEGAL_ENTITY_SG_LEGAL_ENTITY_NAME', pac.assignment_action_id), pay_sg_iras_archive.get_archive_value('X_SG_LEGAL_ENTITY_SG_ER_INCOME_TAX_NUMBER',pac.assignment_action_id), pay_sg_iras_archive.get_archive_value('X_PEOPLE_FLEXFIELD_SG_SG_LEGAL_NAME',pac.assignment_action_id), pay_sg_iras_archive.get_archive_value('X_PER_NATIONAL_IDENTIFIER', pac.assignment_action_id), pay_sg_iras_archive.get_archive_value('X_PEOPLE_FLEXFIELD_SG_SG_INCOME_TAX_NUMBER', pac.assignment_action_id), to_number(pay_sg_iras_archive.get_archive_value('X_IR8S_MOA_408_PER_LE_YTD', pac.assignment_action_id))*/ PAY PYSG8SAD_XML US PAY IR8S Ad Hoc Printed Report New Application: Payroll Source: IR8S Ad Hoc Printed Report New (XML) Short Name: PYSG8SAD_XML DB package: PAY_PYSG8SAD_XMLP_PKG BI Publisher :cp_asg_set_name :cp_aw :cp_aw_amt :cp_aw_apr_fund :cp_aw_cpf_ee :cp_aw_cpf_er :cp_aw_fr_date :cp_aw_to_date :cp_basis_end :cp_cpf_cap_no :cp_cpf_cap_yes :cp_ee_contrib :cp_ee_date :cp_ee_intr :cp_emp_no :cp_er_contrib :cp_er_date :cp_er_intr :cp_ow :cp_ow_apr_fund :cp_ow_cpf_ee :cp_ow_cpf_er :cp_refund_date :cp_sys_date :p_assignment_set_id :p_basis_end :p_basis_start :p_basis_year :p_business_group_id :p_conc_request_id :p_legal_entity :p_payroll_action_id :p_person_id 1 10 :p_assignment_set_id Number US P_ASSIGNMENT_SET_ID 2 20 :p_basis_year Number US P_BASIS_YEAR 3 30 :p_business_group_id Number US P_BUSINESS_GROUP_ID 4 40 :p_legal_entity Number US P_LEGAL_ENTITY 5 50 :p_payroll_action_id Number US P_PAYROLL_ACTION_ID 6 60 :p_person_id Number US P_PERSON_ID 7 70 :p_basis_start Char US P_BASIS_START 8 80 :p_basis_end Char US P_BASIS_END