Report Name : Payslip Report (HCM)
Report Path : /Human Capital Management/Payroll/Payment Distribution/Payslip.xdo
Use case : View payslip of employee
Empoloyee Name :Alkhateeb Hamad
Person Number :418
Customized Format :
What Customization do the customer need ?
What is the customization Process ?
bursting query in Payslip report
----------------------------------
with del_opt as (
select del_opt.bip_template_name
, del_opt.output_type
, del_opt.calendar_code
, del_opt.output_name
, del_opt.ext_delivery_option_id
, del_opt.delivery_type
, data_ele.information_column
, prr.report_block_id
, prr.report_record_id
, prr.effective_start_date
, prr.effective_end_date
from per_ext_delivery_options_b del_opt
, per_ext_delivery_option_dtls del_det
, per_ext_data_elements_b data_ele
, pay_report_records_f prr
where del_opt.ext_delivery_option_id = :deliveryOptionId
and del_opt.ext_delivery_option_id = del_det.ext_delivery_option_id
AND del_det.option_type = 'KEY'
AND del_det.option_data_element_id = data_ele.ext_data_element_id
AND data_ele.report_record_id = prr.report_record_id
)
SELECT /*+ index(ps_act PAY_PAYROLL_ACTIONS_PK)
index(lck PAY_ACTION_INTERLOCKS_PK)
index(pra_archive PAY_PAYROLL_REL_ACTIONS_PK)
index(pact PAY_PAYROLL_ACTIONS_PK)
index(actinfo PAY_ACTION_INFORMATION_N6)*/
actinfo.action_information14 KEY
, del_opt.bip_template_name TEMPLATE
, del_opt.output_type OUTPUT_FORMAT
, pay_report_delivery.get_output_file_name(del_opt.output_name
,pact.effective_date
,del_opt.ext_delivery_option_id
,del_opt.delivery_type
,actinfo.action_information_id
,actinfo.action_context_type
,actinfo.action_context_id) OUTPUT_NAME
, del_opt.calendar_code CALENDAR
, 'true' SAVE_OUTPUT
, DECODE(del_opt.delivery_type,'DOR',NULL,'NONE',NULL,'HCMCONNECT'
,NULL,del_opt.delivery_type) DEL_CHANNEL
, pay_report_delivery.get_del_param_value('1'
,del_opt.ext_delivery_option_id
,del_opt.delivery_type
,actinfo.action_information_id
,actinfo.action_context_type
,actinfo.action_context_id) PARAMETER1
, pay_report_delivery.get_del_param_value('2'
,del_opt.ext_delivery_option_id
,del_opt.delivery_type
,actinfo.action_information_id
,actinfo.action_context_type
,actinfo.action_context_id) PARAMETER2
, pay_report_delivery.get_del_param_value('3'
,del_opt.ext_delivery_option_id
,del_opt.delivery_type
,actinfo.action_information_id
,actinfo.action_context_type
,actinfo.action_context_id) PARAMETER3
, pay_report_delivery.get_del_param_value('4'
,del_opt.ext_delivery_option_id
,del_opt.delivery_type
,actinfo.action_information_id
,actinfo.action_context_type
,actinfo.action_context_id) PARAMETER4
, pay_report_delivery.get_del_param_value('5'
,del_opt.ext_delivery_option_id
,del_opt.delivery_type
,actinfo.action_information_id
,actinfo.action_context_type
,actinfo.action_context_id) PARAMETER5
, pay_report_delivery.get_del_param_value('6'
,del_opt.ext_delivery_option_id
,del_opt.delivery_type
,actinfo.action_information_id
,actinfo.action_context_type
,actinfo.action_context_id) PARAMETER6
, pay_report_delivery.get_del_param_value('7'
,del_opt.ext_delivery_option_id
,del_opt.delivery_type
,actinfo.action_information_id
,actinfo.action_context_type
,actinfo.action_context_id) PARAMETER7
, pay_report_delivery.get_del_param_value('8'
,del_opt.ext_delivery_option_id
,del_opt.delivery_type
,actinfo.action_information_id
,actinfo.action_context_type
,actinfo.action_context_id) PARAMETER8
, pay_report_delivery.get_del_param_value('9'
,del_opt.ext_delivery_option_id
,del_opt.delivery_type
,actinfo.action_information_id
,actinfo.action_context_type
,actinfo.action_context_id) PARAMETER9
, pay_report_delivery.get_del_param_value('10'
,del_opt.ext_delivery_option_id
,del_opt.delivery_type
,actinfo.action_information_id
,actinfo.action_context_type
,actinfo.action_context_id) PARAMETER10
, pay_report_delivery.get_del_param_value('LOCALE'
,del_opt.ext_delivery_option_id
,del_opt.delivery_type
,actinfo.action_information_id
,actinfo.action_context_type
,actinfo.action_context_id) LOCALE
, pay_report_delivery.get_del_param_value('TIMEZONE'
,del_opt.ext_delivery_option_id
,del_opt.delivery_type
,actinfo.action_information_id
,actinfo.action_context_type
,actinfo.action_context_id) TIMEZONE
FROM del_opt
, pay_payroll_actions ps_act
, pay_payroll_rel_actions pra_payslip
, pay_action_interlocks lck
, pay_payroll_rel_actions pra_archive
, pay_payroll_actions pact
, pay_action_information actinfo
where ps_act.payroll_action_id = :payrollActionId
and pra_payslip.payroll_action_id = ps_act.payroll_action_id
and lck.locking_action_id = pra_payslip.payroll_rel_action_id
and pra_archive.payroll_rel_action_id = lck.locked_action_id
and actinfo.action_context_id = pra_archive.payroll_rel_action_id
and actinfo.action_context_type = 'PRA'
and actinfo.action_information_category = 'GLB_PAY_ARCH_CBID_INFORMATION_FC'
and pact.payroll_action_id = pra_archive.payroll_action_id
AND pact.effective_date BETWEEN del_opt.effective_start_date
AND del_opt.effective_end_date
and (( decode(del_opt.delivery_type, 'NONE', 'PRINT', del_opt.delivery_type)='PRINT' AND
per_report_preferences.get_del_pref_by_sysdoctype('GLB_PAYSLIP'
, decode(del_opt.delivery_type, 'NONE', 'PRINT', del_opt.delivery_type)
, pra_payslip.payroll_rel_action_id
, 'PAYROLL_REL_ACTION_ID'
, ps_act.enterprise_id
, ps_act.effective_date)= 'Y')
OR (decode(del_opt.delivery_type, 'NONE', 'PRINT', nvl(del_opt.delivery_type,'EXCEPT PRINT'))!='PRINT'))
