Introduction
This Post Provides the SQL Query that returns HCM Extract Input Values in BI Report
Query
SELECT TO_DATE (par_val.flow_param_value, ‘YYYY-MM-DD’)
FROM pay_flow_instances flow,
pay_flow_parameters flw_par,
pay_flow_param_values par_val
WHERE flow.instance_name =
(SELECT flow.instance_name
FROM pay_payroll_actions pact,
pay_requests req,
pay_flow_instances flow
WHERE pact.payroll_action_id = :payrollactionid
AND flow.flow_instance_id = req.flow_instance_id
AND req.pay_request_id = pact.pay_request_id)
AND flw_par.base_flow_id = flow.base_flow_id
AND par_val.base_flow_parameter_id = flw_par.base_flow_parameter_id
AND par_val.flow_instance_id = flow.flow_instance_id
AND flw_par.base_flow_parameter_name = ‘PARAMETER_NAME’
To Know More about Post
Email : Doyen.ebiz@gmail.com
