865: ( SELECT DISTINCT ps.assignment_action_id ,
866: src.element_type_id ,
867: 'N' transfered_to_prj
868: FROM
869: pa_pay_audit_all aud ,
870: pay_costing_projects_v src,
871: pa_pay_proj_status_all ps
872: WHERE
873: aud.interface_run_id = p_interface_run_id