SQL on BOM_DEPARTMENT not populating values in CMCACW

Why this is happening in actual cost worker program. When I run SQL outside it returns values while from cost worker program not working. Below SQL failing when running from actual cost worker.

Parameter values are populated.

  SELECT bd.department_id

               INTO l_dept_id

            FROM bom_departments bd,

                 wip_operations wo

            WHERE bd.department_id = wo.department_id

              AND wo.wip_entity_id = p_wip_entity_id

              AND wo.operation_seq_num = p_opseq_num;