676: IF g_ShopFloorMove_rec.fm_department_id IS NOT NULL then
677:
678: SELECT department_code
679: INTO g_ShopFloorMove_rec.fm_department_code
680: FROM bom_departments
681: WHERE department_id = g_ShopFloorMove_rec.fm_department_id;
682:
683: RETURN g_ShopFloorMove_rec.fm_department_code;
684: END IF;
1742: IF g_ShopFloorMove_rec.to_department_id IS NOT NULL then
1743:
1744: SELECT department_code
1745: INTO g_ShopFloorMove_rec.to_department_code
1746: FROM bom_departments
1747: WHERE department_id = g_ShopFloorMove_rec.to_department_id;
1748:
1749: RETURN g_ShopFloorMove_rec.to_department_code;
1750: END IF;