Generate Data Loader File Parameters involving Content ID SQL debugging for copied LDFF Payroll Flow

Summary

Content ID SQL debugging for copied LDFF Payroll Flow

Content

Hello Forum:

Has anyone ever seen or used this SQL statement for a payroll flow CONTENT ID parameter?   My Inbound HDL Transformation FF is not Payroll specific like EE.  My FF produces an update to Assignment DFF for a couple of  specific employee's DFF values.

select a.ddocname   from fusion_ocserver11g.revisions a  where a.ddoctitle = (select b.flow_param_value                         from pay_flow_param_values b                             ,pay_flow_parameters c                        where b.flow_instance_id = :pFlowInstanceId                          and c.base_flow_parameter_id = b.base_flow_parameter_id                          and c.base_flow_parameter_name =