APPS.BOM_DEPARTMENTS_PKG dependencies on BOM_RESOURCES

Line 368: (SELECT RESOURCE_ID FROM BOM_RESOURCES

364: BEGIN
365: SELECT COUNT(RESOURCE_ID) INTO resources_exist FROM BOM_DEPARTMENT_RESOURCES
366: WHERE DEPARTMENT_ID = X_Department_Id
367: AND RESOURCE_ID IN
368: (SELECT RESOURCE_ID FROM BOM_RESOURCES
369: WHERE COST_CODE_TYPE = 4
370: AND AUTOCHARGE_TYPE = 3
371: AND ORGANIZATION_ID = Organization_Id);
372: RETURN(resources_exist);