APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on BOM_DEPARTMENTS

Line 644: FROM bom_departments

640: IF g_ShopFloorMove_rec.fm_department_id IS NOT NULL then
641:
642: SELECT department_code
643: INTO g_ShopFloorMove_rec.fm_department_code
644: FROM bom_departments
645: WHERE department_id = g_ShopFloorMove_rec.fm_department_id;
646:
647: RETURN g_ShopFloorMove_rec.fm_department_code;
648: END IF;

Line 1687: FROM bom_departments

1683: IF g_ShopFloorMove_rec.to_department_id IS NOT NULL then
1684:
1685: SELECT department_code
1686: INTO g_ShopFloorMove_rec.to_department_code
1687: FROM bom_departments
1688: WHERE department_id = g_ShopFloorMove_rec.to_department_id;
1689:
1690: RETURN g_ShopFloorMove_rec.to_department_code;
1691: END IF;